Enhancing SQL Table Acquisition with Reverse Engineering for Text-to-SQL

Shixin Liu, Haoyu Xu, Yu Hong


Abstract
Text-to-SQL oriented table acquisition suffers from heterogeneous semantic gap. To address the issue, we propose a Reverse Engineering (RE) based optimization approach. Instead of forward table search using questions as queries, RE reversely generates potentially-matched question conditioned on table schemas, and promotes semantic consistency verification between homogeneous questions. We experiment on two benchmarks, including SpiderUnion and BirdUnion. The test results show that our approach yields substantial improvements compared to the Retrieval-Reranker (2R) baseline, and achieves competitive performance in both table acquisition and Text-to-SQL tasks.
Anthology ID:
2025.findings-emnlp.425
Volume:
Findings of the Association for Computational Linguistics: EMNLP 2025
Month:
November
Year:
2025
Address:
Suzhou, China
Editors:
Christos Christodoulopoulos, Tanmoy Chakraborty, Carolyn Rose, Violet Peng
Venue:
Findings
SIG:
Publisher:
Association for Computational Linguistics
Note:
Pages:
8034–8041
Language:
URL:
https://preview.aclanthology.org/author-page-yu-wang-polytechnic/2025.findings-emnlp.425/
DOI:
10.18653/v1/2025.findings-emnlp.425
Bibkey:
Cite (ACL):
Shixin Liu, Haoyu Xu, and Yu Hong. 2025. Enhancing SQL Table Acquisition with Reverse Engineering for Text-to-SQL. In Findings of the Association for Computational Linguistics: EMNLP 2025, pages 8034–8041, Suzhou, China. Association for Computational Linguistics.
Cite (Informal):
Enhancing SQL Table Acquisition with Reverse Engineering for Text-to-SQL (Liu et al., Findings 2025)
Copy Citation:
PDF:
https://preview.aclanthology.org/author-page-yu-wang-polytechnic/2025.findings-emnlp.425.pdf
Checklist:
 2025.findings-emnlp.425.checklist.pdf