Search papers, labs, and topics across Lattice.
DBCooker, a novel LLM-based system, automates the synthesis of database-native functions by addressing the limitations of generic LLMs in database-specific development. It uses function characterization to aggregate declarations and trace dependencies, then employs a pseudo-code-based coding plan generator and a hybrid fill-in-the-blank model for logic integration. DBCooker achieves 34.55% higher accuracy than existing methods across SQLite, PostgreSQL, and DuckDB, even synthesizing functions absent in the latest SQLite version.
LLMs can now cook up database-native functions with 34% higher accuracy, even creating entirely new functions missing from current database versions.
Database systems incorporate an ever-growing number of functions in their kernels (a.k.a., database native functions) for scenarios like new application support and business migration. This growth causes an urgent demand for automatic database native function synthesis. While recent advances in LLM-based code generation (e.g., Claude Code) show promise, they are too generic for database-specific development. They often hallucinate or overlook critical context because database function synthesis is inherently complex and error-prone, where synthesizing a single function may involve registering multiple function units, linking internal references, and implementing logic correctly. To this end, we propose DBCooker, an LLM-based system for automatically synthesizing database native functions. It consists of three components. First, the function characterization module aggregates multi-source declarations, identifies function units that require specialized coding, and traces cross-unit dependencies. Second, we design operations to address the main synthesis challenges: (1) a pseudo-code-based coding plan generator that constructs structured implementation skeletons by identifying key elements such as reusable referenced functions; (2) a hybrid fill-in-the-blank model guided by probabilistic priors and component awareness to integrate core logic with reusable routines; and (3) three-level progressive validation, including syntax checking, standards compliance, and LLM-guided semantic verification. Finally, an adaptive orchestration strategy unifies these operations with existing tools and dynamically sequences them via the orchestration history of similar functions. Results show that DBCooker outperforms other methods on SQLite, PostgreSQL, and DuckDB (34.55% higher accuracy on average), and can synthesize new functions absent in the latest SQLite (v3.50).
