GenLink: Generation-Driven Schema-Linking via Multi-Model Learning for Text-to-SQL

Zhifeng Hao, Junqi Huang, Shaobin Shi, Ruichu Cai, Boyan Xu


Abstract
Schema linking is widely recognized as a key factor in improving text-to-SQL performance. Supervised fine-tuning approaches enhance SQL generation quality by explicitly fine-tuning schema linking as an extraction task. However, they suffer from two major limitations: (i) The training corpus of small language models restricts their cross-domain generalization ability. (ii) The extraction-based fine-tuning process struggles to capture complex linking patterns. To address these issues, we propose GenLink, a generation-driven schema-linking framework based on multi-model learning. Instead of explicitly extracting schema elements, GenLink enhances linking through a generation-based learning process, effectively capturing implicit schema relationships. By integrating multiple small language models, GenLink improves schema-linking recall rate and ensures robust cross-domain adaptability. Experimental results on the BIRD and Spider benchmarks validate the effectiveness of GenLink, achieving execution accuracies of 67.34% (BIRD), 89.7% (Spider development set), and 87.8% (Spider test set), demonstrating its superiority in handling diverse and complex database schemas.
Anthology ID:
2025.emnlp-main.1518
Volume:
Proceedings of the 2025 Conference on Empirical Methods in Natural Language Processing
Month:
November
Year:
2025
Address:
Suzhou, China
Editors:
Christos Christodoulopoulos, Tanmoy Chakraborty, Carolyn Rose, Violet Peng
Venue:
EMNLP
SIG:
Publisher:
Association for Computational Linguistics
Note:
Pages:
29880–29893
Language:
URL:
https://preview.aclanthology.org/ingest-emnlp/2025.emnlp-main.1518/
DOI:
Bibkey:
Cite (ACL):
Zhifeng Hao, Junqi Huang, Shaobin Shi, Ruichu Cai, and Boyan Xu. 2025. GenLink: Generation-Driven Schema-Linking via Multi-Model Learning for Text-to-SQL. In Proceedings of the 2025 Conference on Empirical Methods in Natural Language Processing, pages 29880–29893, Suzhou, China. Association for Computational Linguistics.
Cite (Informal):
GenLink: Generation-Driven Schema-Linking via Multi-Model Learning for Text-to-SQL (Hao et al., EMNLP 2025)
Copy Citation:
PDF:
https://preview.aclanthology.org/ingest-emnlp/2025.emnlp-main.1518.pdf
Checklist:
 2025.emnlp-main.1518.checklist.pdf