Skip to content

Distilled documentation for dialect-specific SQL generation

Jul 2026 · The VLDB journal · Vol 35 · 0 citations · 39 references
Computer Science

TL;DR

This work analyzes query logs from MotherDuck, a cloud analytics platform built on DuckDB, to show that real-world SQL extends far beyond analytical queries, with users frequently employing dialect-specific functionality that LLMs struggle with.

View source

Similar papers

Book Open access Aug 2026

AutoSQL: Extracting SQL Templates from Imperative ORM Code in Large-Scale Repositories

This work presents AutoSQL, a system that reconstructs SQL templates from Go ORM code that constructs a Code Index, a directed graph that captures structural dependencies between functions, types, and global variables as navigable edges and synthesizes SQL templates.

Jun-Song Pu, Yi-Chen Li, Zhuang-Bin Chen et al. · 0 citations
Book Open access Aug 2026

Turning Parser Errors into Suggestions for REPL-Driven DSLs (Functional Pearl)

A fresh perspective is presented that turns parser errors -- traditionally seen as roadblocks -- into opportunities for generating valid, context-aware autocomplete suggestions, enabling domain-specific languages to provide basic development assistance with minimal overhead.

M. Gissurarson, Elisabet Lobo-Vesga, Alejandro Russo · 0 citations
Preprint Aug 2026

Beyond the Harness: End-to-End Optimization of Context Artifacts for Enterprise Text-to-SQL

In this ablation, retrieved knowledge-base context provides the largest marginal improvement when added to the full oracle graph, and a distillation procedure that turns historical query profiles into reusable SQL reference cards is optimized.

Kate Gwimm, Carson Eisenach · 0 citations
Preprint Aug 2026

Doc2CI: A Multi-Service Study of CI Configuration Generation Using Large Language Models

A large empirical study on using LLMs to generate CI configurations from natural language across services and model families suggests that similarity and validity are distinct objectives for CI generation and motivate schema-aware evaluation and tooling for LLM-based configuration generation.

T. A. Ghaleb · 0 citations
Preprint Aug 2026

Code as Representation: A Compilable Parsing Paradigm for Academic Documents

Compilable Academic Document Parsing (CADP) is proposed, a paradigm that reconstructs a full page as contextual \LaTeX{} plus executable Python, so that structure-preserving elements and executable chart representations can be reconstructed, recompiled, and directly verified against the source page.

Rihui Jin, Jun Wang, Chen Zhu et al. · 0 citations
Preprint Aug 2026

PLSQLBench: Benchmarking LLM Systems for Executable Procedural Database Programming

PLSQLBench is the first benchmark for evaluating whether LLMs can write executable PL/SQL programs, with correctness measured through execution-based tests, and recurring difficulties in schema grounding, PL/SQL dialect fidelity, procedural control flow, exception handling, and cross-turn consistency are revealed.

Marianne Menglin Liu, Leonid Boytsov, Daniel W. Peterson et al. · 0 citations

We use cookies to run the site and, with your consent, for analytics and to show ads. See our Cookie Policy.