The Prompt() Function: Use the Power of LLMs with SQL

MotherDuck has announced a new SQL function called prompt(), which integrates small language models such as OpenAI's gpt-4o-mini into SQL data warehouses. The function is designed for text generation, summarization, and structured data extraction without separate infrastructure. It is now available in Preview for MotherDuck users to apply advanced natural language processing techniques more cost-effectively and with simplicity.

• The prompt() function supports gpt-4o-mini and gpt-4o models.
• It allows text summarization and structured data extraction directly in SQL.
• The function supports concurrency, processing up to 256 requests at once.
• Using DuckDB's regex_extract might be more efficient for simple text operations.
• MotherDuck offers a Free Trial with 40 compute unit hrs/day.