MotherDuck Research

Advancing the future of data + AI.

Publications

All Caching Code Generation Cost-Based Optimization Data Apps Data Lineage Data Transformation Data Wrangling DuckDB Entity Matching Hybrid Query Processing LLM MotherDuck Query Optimization Schema Documentation Serverless Analytics Text-to-SQL

Query-Log-Informed Schema Descriptions and their Impact on Text-to-SQL

DuckDBMotherDuckSchema DocumentationText-to-SQL

Query-Log-Informed Schema Descriptions and their Impact on Text-to-SQL

Automatically generating schema documentation from historical query logs to improve LLM-powered Text-to-SQL. Tested on both the BIRD benchmark and MotherDuck’s production data warehouse, query pattern descriptions boost SQL generation accuracy by up to 16% on real-world data.

LEARN MORE