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. |
Similar Papers
Global Reasoning over Database Structures for Text-to-SQL Parsing (D19-1)
Copied to clipboard
| Challenge: | Existing semantic parsers only select a set of database constants at training time . current models only consider local information, not global ones . |
| Approach: | They propose a semantic parser that globally reasons about the structure of the query to make a more contextually-informed selection of database constants. |
| Outcome: | The proposed model increases accuracy from 39.4% to 47.4% on a zero-shot semantic parsing dataset with complex databases. |
Improving Text-to-SQL Semantic Parsing with Fine-grained Query Understanding (2022.emnlp-industry)
Copied to clipboard
Jun Wang, Patrick Ng, Alexander Hanbo Li, Jiarong Jiang, Zhiguo Wang, Bing Xiang, Ramesh Nallapati, Sudipta Sengupta
| Challenge: | Recent research on Text-to-SQL semantic parsing relies on parser or heuristic based approach to understand natural language query. |
| Approach: | They propose a general-purpose, modular neural semantic parsing framework that is based on token-level fine-grained query understanding. |
| Outcome: | The proposed framework outperforms the state-of-the-art model by 2.7% on a WikiTableQuestions test set. |
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 . |
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. |
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. |
Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsing (2020.findings-emnlp)
Copied to clipboard
| Challenge: | BRIDGE is a powerful sequential architecture for cross-modal semantic parsing . BRidege captures cross-modal dependencies between natural language questions and relational databases . |
| Approach: | They propose a sequential architecture that captures cross-modal dependencies between questions and relational databases in cross-DB semantic parsing. |
| Outcome: | The proposed architecture performs well on the well-studied Spider benchmark (65.5% dev, 59.2% test). |
Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing (P19-1)
Copied to clipboard
| Challenge: | Semantic parsing to SQL has largely ignored the structure of the database schema . a recent study used a simple DB that was observed at both training and test time. |
| Approach: | They propose a semantic parser where the schema structure is encoded with a graph neural network and used at both encoding and decoding time. |
| Outcome: | The proposed parser improves from 33.8% to 39.4%, dramatically above the current state of the art, which is at 19.7%. |
UCS-SQL: Uniting Content and Structure for Enhanced Semantic Bridging In Text-to-SQL (2025.findings-acl)
Copied to clipboard
Zhenhe Wu, Zhongqiu Li, JieZhangChinaTele JieZhangChinaTele, Zhongjiang He, Jian Yang, Yu Zhao, Ruiyu Fang, Bing Wang, Hongyan Xie, Shuangyong Song, Zhoujun Li
| Challenge: | Existing methods overlook the challenge of effectively transforming structure information from NL to SQL. |
| Approach: | They propose a text-to-SQL framework that unites content and structure pipes to bridge the gap between NL and SQL. |
| Outcome: | The proposed framework bridges the gap between natural language questions and SQL by combining content and structure pipes. |
GenLink: Generation-Driven Schema-Linking via Multi-Model Learning for Text-to-SQL (2025.emnlp-main)
Copied to clipboard
| Challenge: | Experimental results on BIRD and Spider benchmarks validate the effectiveness of GenLink. |
| Approach: | They propose a generation-driven schema-linking framework based on multi-model learning . experimental results validate the effectiveness of GenLink . |
| Outcome: | Experimental results show that GenLink improves schema-linking recall rate and cross-domain adaptability. |
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. |