11 articles tagged with #text-to-sql. AI-curated summaries with sentiment analysis and key takeaways from 50+ sources.
Researchers introduce APEX-SQL, an agentic framework that improves Text-to-SQL systems by using hypothesis-verification loops and real data exploration instead of static schema representations. The system achieves 70.65% execution accuracy on BIRD and 51.01% on Spider 2.0-Snow benchmarks, demonstrating significant performance gains for enterprise database query generation.
SIRIUS-SQL introduces a multi-candidate approach to Text-to-SQL generation that addresses redundancy, execution error classification, and selector limitations through difficulty-smoothing reinforcement learning, targeted repair mechanisms, and hybrid confidence-gated selection. The system achieves 75.88% accuracy on BIRD dev and 91.20% on SPIDER test, surpassing previous state-of-the-art multi-candidate systems.
EviLink is a new AI framework that improves Text-to-SQL systems by treating schema linking as an uncertainty-aware process across multiple SQL paths rather than a single deterministic selection. The approach balances schema completeness, relevance, and computational cost, achieving 90.15% field-level recall on Spider2-Snow while using fewer tokens than existing methods.
CORE-T introduces a training-free framework for improving table retrieval in text-to-SQL systems by combining dense retrieval with LLM-generated metadata and compatibility caching. The approach achieves significant performance gains—up to 22.7 points in table-selection F1 and 24.4 points in multi-table execution accuracy—while reducing inference tokens by 64-76% compared to LLM-intensive alternatives.
Researchers introduce CA-SQL, an advanced Text-to-SQL pipeline that dynamically allocates computational resources based on task complexity to improve LLM reasoning. The method achieves state-of-the-art performance on the BIRD benchmark's challenging tier using only GPT-4o-mini, outperforming larger models and demonstrating the efficiency gains possible through intelligent inference-time optimization.
Researchers propose LatentRefusal, a safety mechanism for LLM-based text-to-SQL systems that detects unanswerable queries by analyzing intermediate hidden activations rather than relying on output-level instruction following. The approach achieves 88.5% F1 score across four benchmarks while adding minimal computational overhead, addressing a critical deployment challenge in AI systems that generate executable code.
Researchers introduce CBR-to-SQL, a new framework using Case-Based Reasoning to improve natural language-to-SQL translation for healthcare databases. The system addresses limitations of standard RAG approaches by using two-stage retrieval and abstract case templates, achieving state-of-the-art results on medical datasets.
Researchers propose Struct-SQL, a knowledge distillation framework that improves Small Language Models for Text-to-SQL tasks by using structured Chain-of-Thought reasoning instead of unstructured approaches. The method achieves an 8.1% improvement over baseline distillation, primarily by reducing syntactic errors through formal query execution plan blueprints.
Researchers introduce EvoSchema, a comprehensive benchmark to test how well text-to-SQL AI models handle database schema changes over time. The study reveals that table-level changes significantly impact model performance more than column-level modifications, and proposes training methods to improve model robustness in dynamic database environments.
SpotIt+ is a new open-source tool that evaluates Text-to-SQL systems through verification-based testing, actively searching for database instances that reveal differences between generated and ground truth SQL queries. The tool incorporates constraint-mining that combines rule-based specification mining with LLM validation to generate more realistic test scenarios.
Researchers introduce SpotIt, a new evaluation method for Text-to-SQL systems that uses formal verification to find database instances where generated queries differ from ground-truth queries. Testing on the BIRD dataset revealed that current test-based evaluation methods often miss differences between generated and correct SQL queries.
