Text-to-SQL Benchmarks Toward Enterprise Realities: Under Massive Scopes, Complex Schemas and Scattered Knowledge

Yuchen Ji, Chengxi Yu, Jie Shi, Weixin Zhou, Xi Cao, Jiaqing Liang, Hai Chen, Yu Mao, Deqing Yang, Yanghua Xiao


Abstract
Existing Text-to-SQL benchmarks remain idealized compared with enterprise scenarios, which require massive query scopes, complex schemas, and scattered external knowledge. We present BIRD-Ent and Spider-Ent, two enterprise-oriented benchmarks constructed via a refinement framework, together with Dual-Retrieval-Augmented-Generation (DRAG) Text-to-SQL, which formalizes table-schema and knowledge retrieval before SQL generation. The benchmarks feature over 4,000 columns per query and, for BIRD-Ent, documents totaling 1.5M tokens. Evaluation on state-of-the-art models shows sharp drops, with only 39.1% EX on BIRD-Ent and 60.5% EX on Spider-Ent. These results establish the Ent-series as a discriminative testbed for structurally robust and retrieval-aware Text-to-SQL.
Anthology ID:
2026.findings-emnlp.1971
Volume:
Findings of the Association for Computational Linguistics: EMNLP 2026
Month:
October
Year:
2026
Address:
Budapest, Hungary
Editors:
Hung-Yi Lee, Sunipa Dev, Jessy Li, Desmond Elliott
Venue:
Findings
SIG:
SIGDAT
Publisher:
Association for Computational Linguistics
Note:
Pages:
42028–42060
Language:
URL:
https://aclanthology.org/2026.findings-emnlp.1971/
DOI:
10.18653/2026.findings-emnlp.1971
Bibkey:
Cite (ACL):
Yuchen Ji, Chengxi Yu, Jie Shi, Weixin Zhou, Xi Cao, Jiaqing Liang, Hai Chen, Yu Mao, Deqing Yang, and Yanghua Xiao. 2026. Text-to-SQL Benchmarks Toward Enterprise Realities: Under Massive Scopes, Complex Schemas and Scattered Knowledge. In Findings of the Association for Computational Linguistics: EMNLP 2026, pages 42028–42060, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
Text-to-SQL Benchmarks Toward Enterprise Realities: Under Massive Scopes, Complex Schemas and Scattered Knowledge (Ji et al., Findings 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.findings-emnlp.1971.pdf