Rethinking Schema Linking: A Context-Aware Bidirectional Retrieval Approach for Text-to-SQL (2026.findings-eacl)
Copied to clipboard
| Challenge: | Recent methods focus on improving SQL generation but neglect retrieval of relevant schema elements. |
| Approach: | They propose a context-aware bidirectional schema retrieval framework that treats schema linking as a standalone problem. |
| Outcome: | The proposed framework improves schema recall while reducing false positives. |
Similar Papers
SchemaGraphSQL: Efficient Schema Linking with Pathfinding Graph Algorithms for Text-to-SQL on Large-Scale Databases (2026.findings-eacl)
Copied to clipboard
AmirHossein Safdarian, Milad Mohammadi, Ehsan Jahanbakhsh Bashirloo, Mona Shahamat Naderi, Heshaam Faili
| Challenge: | Text-to-SQL systems translate natural language questions into executable SQL queries. |
| Approach: | They propose a schema linking approach that first constructs a graph based on foreign key relations and then uses a single prompt to a lightweight LLM to extract source and destination tables from the user query. |
| Outcome: | The proposed method outperforms specialized, fine-tuned, and complex multi-step approaches on BIRD and Spider 2.0 benchmarks. |
LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQL (2025.emnlp-main)
Copied to clipboard
| Challenge: | Existing Text-to-SQL models fail to address schema linking problems in large-scale multi-database environments. |
| Approach: | They propose a framework that aims to enable non-expert users to retrieve data effortlessly . they highlight four core errors leading to schema linking failures . |
| Outcome: | The proposed framework outperforms baselines on all schema linking metrics. |
Re-examining the Role of Schema Linking in Text-to-SQL (2020.emnlp-main)
Copied to clipboard
| Challenge: | Existing text-to-SQL models treat schema linking as a minor component . Existing solutions treat schema as merely a string component based on string matching . |
| Approach: | They build a schema linking corpus based on a Spider text-to-SQL dataset . they find schema linking is the crux for the current text- to-Sql task . |
| Outcome: | The proposed model performs well on the Spider text-to-SQL dataset despite its simplicity. |
DCG-SQL: Enhancing In-Context Learning for Text-to-SQL with Deep Contextual Schema Link Graph (2025.acl-long)
Copied to clipboard
| Challenge: | Existing methods for Text-to-SQL show little improvement compared to random selections . Existing approaches rely on intrinsic capabilities of hyper-scaled LLMs, not useful demonstrations. |
| Approach: | They propose a novel approach to effectively retrieving demonstrations and generating SQL queries by linking a question and its database schema items. |
| Outcome: | The proposed method shows consistent improvements in performance and efficiency across hyper-scaled LLMs and small LLM. |
RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers (2020.acl-main)
Copied to clipboard
| Challenge: | Existing semantic parsing models struggle to generalize to unseen database schemas. |
| Approach: | They propose a framework to address schema encoding, schema linking, and feature representation within a text-to-SQL encoder. |
| Outcome: | The proposed framework boosts the match accuracy to 57.2% on the spider dataset, surpassing its best counterparts by 8.7%. |
Solid-SQL: Enhanced Schema-linking based In-context Learning for Robust Text-to-SQL (2025.coling-main)
Copied to clipboard
| Challenge: | Existing text-to-SQL approaches have overlooked the critical aspect of system robustness. |
| Approach: | They propose a robust text-to-SQL solution that integrates with LLMs . their method achieves SOTA SQL execution accuracy levels of 82.1% and 58.9% . |
| Outcome: | The proposed solution achieves SOTA SQL execution accuracy levels of 82.1% and 58.9% on the general Spider and Bird benchmarks. |
Bidirectional Semantic Enhancement for Schema Routing Across Large-Scale Databases (2026.findings-acl)
Copied to clipboard
| Challenge: | Existing methods relying on unidirectional query expansion fail to bridge lexical mismatches and graph-based approaches struggle to navigate schemas when explicit structural links are missing. |
| Approach: | They propose a retrieval framework that bridges the semantic gap between user queries and vague schema definitions by performing online generative query expansion. |
| Outcome: | The proposed retrieval framework bridges the semantic gap between user queries and vague schema definitions by enriching table schemas offline and performing online generative query expansion. |
Re-appraising the Schema Linking for Text-to-SQL (2023.findings-acl)
Copied to clipboard
| Challenge: | Recent work has shown that schema linking reduces robustness of text-to-SQL models . EMSL is used to correlate natural language queries with the given database schema . |
| Approach: | They propose a grammar linking module to help model align grammar references with SQL keywords. |
| Outcome: | The proposed language model improves performance without using EMSL, the authors show . their language model is more robust, and the proposed grammar linking improves interoperability . |
A Tale of Two Linkings: Dynamically Gating between Schema Linking and Structural Linking for Text-to-SQL Parsing (2020.coling-main)
Copied to clipboard
| Challenge: | Existing methods for text-to-SQL semantic parsing require strict structured prediction due to its application scenario where the output SQL will be sent to an executor program directly. |
| Approach: | They propose to use schema linking and structural linking to link NL to the database schema. |
| Outcome: | The proposed method shows significant gains on the Spider dataset. |
Gen-SQL: Efficient Text-to-SQL By Bridging Natural Language Question And Database Schema With Pseudo-Schema (2025.coling-main)
Copied to clipboard
| Challenge: | Recent studies have shifted paradigms and leveraged Large Language Models (LLMs) to tackle the challenging task of Text-to-SQL. |
| Approach: | They propose a framework that leverages large language models to generate SQL queries . they exploit prior knowledge from the LLM to enhance embedding-based retriever . |
| Outcome: | The proposed method improves embedding-based retriever and reduces cost. |