When the Bottleneck Shifts: Diagnosing and Closing Information Gaps in Interactive Text-to-SQL

Mengyi Yan, Zhinian Ma, Yue Wang, Yaoshu Wang, Xiaoke Zhu, Zizhe Wang, Haoyi Zhou, Zhumin Chen


Abstract
In interactive text-to-SQL, the evidence needed to write correct SQL is not given upfront but distributed across schema, knowledge bases, and users, and must be acquired through costly environment interactions under a finite budget. We observe that strong LLMs often fail not from deficient SQL synthesis, but from premature commitment to SQL before acquiring task-critical evidence. Through controlled trajectory analysis, we formalize this observation as the Information Sufficiency Hypothesis and identify a five-class gap taxonomy that structures the acquisition space. Guided by this diagnosis, we develop PASCAL, a training-free acquisition-control data agent framework that interposes a source-aware information-acquisition layer before SQL generation and schedules acquisition by cost-normalized priority. On BIRD-Interact, PASCAL with a local 35B backbone achieves 51.0% Phase-1 and 37.0% two-phase success rate, outperforming frontier models leaderboard result by up to 14.7 percentage points, with gains concentrated on BI tasks requiring cross-source evidence acquisition.
Anthology ID:
2026.emnlp-main.465
Volume:
Proceedings of the 2026 Conference on Empirical Methods in Natural Language Processing
Month:
October
Year:
2026
Address:
Budapest, Hungary
Editors:
Hung-Yi Lee, Sunipa Dev, Jessy Li, Desmond Elliott
Venue:
EMNLP
SIG:
SIGDAT
Publisher:
Association for Computational Linguistics
Note:
Pages:
10655–10687
Language:
URL:
https://aclanthology.org/2026.emnlp-main.465/
DOI:
Bibkey:
Cite (ACL):
Mengyi Yan, Zhinian Ma, Yue Wang, Yaoshu Wang, Xiaoke Zhu, Zizhe Wang, Haoyi Zhou, and Zhumin Chen. 2026. When the Bottleneck Shifts: Diagnosing and Closing Information Gaps in Interactive Text-to-SQL. In Proceedings of the 2026 Conference on Empirical Methods in Natural Language Processing, pages 10655–10687, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
When the Bottleneck Shifts: Diagnosing and Closing Information Gaps in Interactive Text-to-SQL (Yan et al., EMNLP 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.emnlp-main.465.pdf