Learning to Recover Bridge Path for SQL Schema Linking via Tentative Answer Profiling

Wenzhong Qiu, Shixin Liu, Yu Hong


Abstract
Schema linking is a task of investigating relevant SQL schema (items and paths) for a specific query language. Constructing a reliable linker is crucial for Text2SQL auto-coding since it provides informative clues for directing SQL coders. Current studies have obtained considerable performance gains when independently evaluating linkers, which allow F1-score to be higher than 90% at best. However, our observation illustrates that the existing linkers still suffers from a high missing rate of Bridge Path, i.e., omitting one or a series of SQL keywords that link across SQL tables. To address the issue, we propose to enhance linkers by Bridge Path Recovering (abbr., BPR) via Tentative Answer Profiling (TAP). On the one hand, BPR is implemented by learning to rank up the better bridged schemata during finetuning. On the other hand, TAP tentatively conjectures possible answers for the query language, and generates their profiles (types and CoT steps) to guide BPR. This is inspired by the experience that answer conjecturing contributes to reversely deducing the multi-hop routing path over SQL tables. Technologically, we train LLaMA-3.1 for TAP, where teacher-student distillation is conducted via Deepseek-3. To ensure sufficient ranking data used for training BPR, we employ a multilevel retrieval technique to align profiles with diverse schemata. We experiment on the benchmark datasets BIRD and Spider. The experimental results show that our approach (BPR-TAP) consistently yields improvements for F1-score upon all benchmarks, and surpasses multiple competitive schema linkers. All source codes are available at https://anonymous.4open.science/r/BPR-TAP-Text2SQL.
Anthology ID:
2026.findings-emnlp.965
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:
20413–20429
Language:
URL:
https://aclanthology.org/2026.findings-emnlp.965/
DOI:
10.18653/2026.findings-emnlp.965
Bibkey:
Cite (ACL):
Wenzhong Qiu, Shixin Liu, and Yu Hong. 2026. Learning to Recover Bridge Path for SQL Schema Linking via Tentative Answer Profiling. In Findings of the Association for Computational Linguistics: EMNLP 2026, pages 20413–20429, Budapest, Hungary. Association for Computational Linguistics.
Cite (Informal):
Learning to Recover Bridge Path for SQL Schema Linking via Tentative Answer Profiling (Qiu et al., Findings 2026)
Copy Citation:
PDF:
https://aclanthology.org/2026.findings-emnlp.965.pdf