Skip to content
Conference Open access

Text-to-SQL with Large Language Models: Challenges Revisited and New Dimensions

2026 · Proceedings of the 15th International Conference on Data Science, Technology and Applications · pp. 621-628 · 0 citations · 64 references

TL;DR

This position paper argues that each original challenge for LLM-based Text-to-SQL has given rise to a new dimension, and synthesizes these concerns and outlines a research agenda along three horizons, arguing for trustworthiness, interactivity, and economic sustainability as first-class concerns.

Abstract

: Building on a prior analysis that identified five key challenges for LLM-based Text-to-SQL (response time, scalability, hallucinations, dataset representativeness, and knowledge acquisition), this position paper argues that each original challenge has given rise to a new dimension: response-time and scalability pressures produced agentic approaches; the pursuit of accuracy on complex queries led to reasoning models; hallucination research exposed the deeper trustworthiness problem, including security; static-benchmark limitations motivated conversational evaluation; and scalability became an economic question, surfacing the open versus proprietary tension. The field has transformed: agentic architectures now surpass 81% execution accuracy on the BIRD test set, yet state-of-the-art systems remain no higher than 17% end-to-end success on multi-turn interactive benchmarks, and backdoor attacks succeed with less than 1% poisoned training data. We synthesize these concerns and outline a research agenda along three horizons, arguing for trustworthiness, interactivity, and economic sustainability as first-class concerns.

Read PDF

Similar papers

Open access Jul 2026

GradeSQL: Outcome reward models for intelligent Text-to-SQL generation from LLMs

As Large Language Models (LLMs) become foundational to next-generation Intelligent Information Systems, the bridge between natural language interfaces and structured database systems remains a critical bottleneck. While Text-to-SQL generation enables cooperative support for complex query formulation, ensuring the reliability of these generated queries at inference time is a central challenge. Conventional methods rely on coarse execution-based signals, which may limit their ability to capture the nuanced semantic alignment required for high-stakes database environments. In this work, we propose the use of Outcome Reward Models (ORMs) as a fine-grained, probabilistic feedback mechanism for test-time verification in Text-to-SQL tasks. We introduce GradeSQL, a framework for training task-specific ORMs that assign scalar utility scores to candidate SQL queries based on their semantic correctness and alignment with database schema. Our approach is evaluated on the BIRD and Spider benchmarks across multiple open-source LLM families. Experimental results demonstrate that ORM-based verification consistently outperforms traditional execution-based heuristics.

M. Tritto, G. Farano, Dario Di Palma et al. · 2 citations
Aug 2026

Agentic-SQL Revisited: Autonomy-Based Taxonomy and Empirical Benchmark Analysis for LLM Text-to-SQL

LLM-based Text-to-SQL progress is reported across heterogeneous benchmarks, backbones, and inference protocols, making cross-system comparison fragile. We reframe the field as a leaderboard aggregation: we collect the metrics authors themselves report and organize them along an inference-autonomy axis spanning constrained, in-context, iterative, agentic, and reasoning-internalized generation, with traceable provenance for every cell. To anchor the aggregation empirically, we run a focused case study on Spider, comparing 8B open-source backbones with and without chain-of-thought (CoT) supervision against few-shot DeepSeek~V3 and GLM-4 baselines. Four patterns emerge: Spider gains transfer unevenly to BIRD and Spider~2.0; autonomy buys robustness at non-trivial cost; reasoning internalization sits between answer-only decoding and externally orchestrated agents; and CoT gains concentrate on Hard and Extra-Hard queries. We release a Python harness mirroring the autonomy axis so that future methods can be added directly to the leaderboard.

Changruo Zhao, Zujun Peng, Yu Tian et al. · 0 citations
Preprint Jul 2026

ABISS: Evaluating Text-to-SQL Systems Through Agent Interaction

A unified taxonomy of 8 categories covering ambiguous and unanswerable questions is addressed, a multi-agent generation pipeline with a two-stage process (NLQ generation followed by SQL grounding) and an explicit Category Conformance validation stage are addressed.

Giovanni Sullutrone, Luca Sala, Sania Aftar et al. · 0 citations
Book Open access Jul 2026

The Poisoned Chalice of LLM Evaluation Report

The first Poisoned Chalice of LLM Evaluation Competition is organized, which frames contamination detection as a white-box membership inference task on source code and provides participants with curated datasets, target models, baseline attacks, and a final evaluation on a held-out model and dataset.

J. Katzy, Ali Al-Kaswan, R. Popescu et al. · 1 citation · ⚡1
Book Open access Aug 2026

Automating End-to-End Hybrid Query Processing: Benchmark, Solution, and Insights

A large-scale benchmark with 60\sim 90× more queries than prior work, built on 3× more databases, an automated pipeline that can execute existing methods without manual intervention, and multi-dimensional, fine-grained evaluation metrics for comprehensive assessment.

Bo Li, Chenzhan Wang, Longkang Lin et al. · 0 citations