EvolSQL: Structure-Aware Evolution for Scalable Text-to-SQL Data Synthesis

Xuanguang Pan, Chongyang Tao, Jiayuan Bai, Jianling Gao, Kai Hua, Ge Zhang, Shuai Ma


Abstract
Training effective Text-to-SQL models remains challenging due to the scarcity of high-quality, diverse, and structurally complex datasets. Existing methods either rely on limited human-annotated corpora, or synthesize datasets directly by simply prompting LLMs without explicit control over SQL structures, often resulting in limited structural diversity and complexity. To address this, we introduce EvolSQL, a structure-aware data synthesis framework that evolves SQL queries from seed data into richer and more semantically diverse forms. EvolSQL starts with an exploratory Query-SQL expansion to broaden question diversity and improve schema coverage, and then applies an adaptive directional evolution strategy using six atomic transformation operators derived from the SQL Abstract Syntax Tree to progressively increase query complexity across relational, predicate, aggregation, and nesting dimensions. An execution-grounded SQL refinement module and schema-aware deduplication further ensure the creation of high-quality, structurally diverse mapping pairs. Experimental results show that a 7B model fine-tuned on our data outperforms one trained on the much larger SynSQL dataset using only 1/18 of the data. Our code is available at https://github.com/slaanurgle/EvolSQL.
Anthology ID:
2026.findings-emnlp.1772
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:
37915–37935
Language:
URL:
https://aclanthology.org/2026.findings-emnlp.1772/
DOI:
Bibkey:
Cite (ACL):
Xuanguang Pan, Chongyang Tao, Jiayuan Bai, Jianling Gao, Kai Hua, Ge Zhang, and Shuai Ma. 2026. EvolSQL: Structure-Aware Evolution for Scalable Text-to-SQL Data Synthesis. In Findings of the Association for Computational Linguistics: EMNLP 2026, pages 37915–37935, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
EvolSQL: Structure-Aware Evolution for Scalable Text-to-SQL Data Synthesis (Pan et al., Findings 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.findings-emnlp.1772.pdf