Bootstrapping Semantic Layer from Execution for Text-to-SQL
Summary
Introduces GATE (Grounding After Test from Execution), a method that bootstraps missing semantic groundings from execution feedback to handle under-specified user phrases in text-to-SQL tasks, consistently improving over strong baselines.
View Cached Full Text
Cached at: 06/05/26, 08:07 AM
# Bootstrapping Semantic Layer from Execution for Text-to-SQL Source: [https://arxiv.org/abs/2606.05634](https://arxiv.org/abs/2606.05634) [View PDF](https://arxiv.org/pdf/2606.05634) > Abstract:Real\-world text\-to\-SQL is often under\-specified until user phrases are grounded in how the database stores values\. Prior work attempts to address this by requiring a semantic layer to specify groundings in advance, but such specifications are often incomplete, especially in expert domains where domain\-specific conventions are under\-documented\. As this leaves multiple grounding hypotheses open for the same SQL part, we introduce GATE \(Grouding After Test from Execution\), which bootstraps missing groundings from execution feedback\. GATE keeps grounding hypotheses open while executing the already grounded parts to obtain observations\. Then, only the hypothesis supported by that observation is grounded and stored as a memory entry, recording what was tested and how the open part should be written in SQL\. These entries accumulate into execution\-grounded memory, allowing later steps to reuse supported groundings\. Across real\-world and controlled benchmarks, GATE consistently improves over strong baselines, demonstrating that execution can serve not only as validation but also as a bootstrapping mechanism for reusable memory in text\-to\-SQL\. ## Submission history From: Youngwon Lee \[[view email](https://arxiv.org/show-email/f1d22049/2606.05634)\] **\[v1\]**Thu, 4 Jun 2026 03:01:04 UTC \(15,567 KB\)
Similar Articles
Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL
Proposes SAGE, a framework for autonomously uncovering latent failure patterns in LLM-based Text-to-SQL generation by generating vulnerability hypotheses and iteratively verifying them. Experiments show SAGE reveals significant model fragility and discovered patterns transfer across models, with preliminary fine-tuning showing promising remediation.
Integrating Reasoning and Generalization in Text-to-SQL via Self-Enhanced Fine-Tuning
This paper proposes CoTE-SQL, a self-enhanced fine-tuning framework for text-to-SQL that integrates self-reasoning traces, structured chain-of-thought prompting, and execution feedback to achieve state-of-the-art performance on Spider and Bird benchmarks.
Learning When to Reason for Text-to-SQL via SFT and DPO
Proposes AutoThinkSQL, a framework that integrates an auto-thinking mechanism into SFT and DPO for Text-to-SQL, enabling the model to dynamically skip reasoning for simple queries and invoke deep CoT for complex ones, achieving gains on Spider and BIRD benchmarks while reducing output tokens by 24.6% and latency by 17.1%.
A Semantic-Layer-Mediated Agent for Natural Language to SQL over Heterogeneous Enterprise Databases
This paper presents a semantic-layer-mediated NL2SQL agent that decouples intent from physical execution by reasoning over a curated semantic model, achieving 94.15% execution accuracy on the Spider2-snow benchmark.
SERL-SQL: Selective Hindsight Distillation for Text-to-SQL Reinforcement Agentic Learning
SERL-SQL proposes a selective execution-grounded reinforcement learning framework for multi-turn Text-to-SQL agents, using teacher-student likelihood gaps to reweight GRPO advantages on SQL action tokens. It achieves strong results on BIRD and Spider benchmarks.