Replacing Training with Memory: Listwise Selection for Text-to-SQL

Yeonseok Jeong, Soyoung Yoon, Seongjun Lee, Seung-Won Hwang


Abstract
Modern Text-to-SQL systems often follow generate-execute-select pipelines, generating multiple candidate queries then selecting the best one. Listwise selection, by jointly comparing multiple candidates, has been widely adopted, but fine-tuning listwise selectors is costly. We thus propose a fine-tuning-free listwise selector. We replace two major fine-tuning objectives with inference-time strategies: (1) learning selection criteria as ordering and (2) mitigating positional bias. First, we build reusable structured memories instead of learning selection behavior as model parameters. Given a question, MAP-SQL retrieves memories distilled from training data that encode how natural language maps to schema elements, SQL operations, and expected outputs. These memories serve as explicit decision criteria for evaluating candidates in a listwise manner. Second, to mitigate ordering bias of listwise selectors, we aggregate rankings across multiple input permutations, with inference cost optimized by execution results and pointwise scoring. Our approach improves selection accuracy while maintaining efficiency and compatibility with existing large language models. Across Text-to-SQL benchmarks, it produces more stable selection without fine-tuning and fewer unnecessary comparisons than existing methods. On BIRD-dev, it outperforms the previous state-of-the-art selector-based method R³-SQL by 2.02 execution accuracy points on average using the same candidate sets, with 2.92× fewer tokens.(https://github.com/ldilab/MAP-SQL)
Anthology ID:
2026.findings-emnlp.2466
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:
53049–53067
Language:
URL:
https://aclanthology.org/2026.findings-emnlp.2466/
DOI:
Bibkey:
Cite (ACL):
Yeonseok Jeong, Soyoung Yoon, Seongjun Lee, and Seung-Won Hwang. 2026. Replacing Training with Memory: Listwise Selection for Text-to-SQL. In Findings of the Association for Computational Linguistics: EMNLP 2026, pages 53049–53067, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
Replacing Training with Memory: Listwise Selection for Text-to-SQL (Jeong et al., Findings 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.findings-emnlp.2466.pdf