Improving Text-to-SQL with Schema Dependency Learning
Not on the map. Why?
Abstract (arXiv)
Text-to-SQL aims to map natural language questions to SQL queries. The sketch-based method combined with execution-guided (EG) decoding strategy has shown a strong performance on the WikiSQL benchmark. However, execution-guided decoding relies on database execution, which significantly slows down the inference process and is hence unsatisfactory for many real-world applications. In this paper, we present the Schema Dependency guided multi-task Text-to-SQL model (SDSQL) to guide the network to effectively capture the interactions between questions and schemas. The proposed model outperforms all existing methods in both the settings with or without EG. We show the schema dependency learning partially cover the benefit from EG and alleviates the need for it. SDSQL without EG significantly reduces time consumption during inference, sacrificing only a small amount of performance and provides more flexibility for downstream applications.
Key facts. Cited by 25 papers in the map (data through 7 Oct 2026). Builds on 28 of its 39 references that are in the map. First posted on arXiv 7 Mar 2021.
Builds on
28 of 39 references.
References · 28
- 2017Attention Is All You Needcited by 59,932
- 2018BERT: Pre-training of Deep Bidirectional Transformers for Language Understandingcited by 40,204
- 2014Adam: A Method for Stochastic Optimizationcited by 36,960
- 2019PyTorch: An Imperative Style, High-Performance Deep Learning Librarycited by 20,160
- 2017Multi-Task Learning Using Uncertainty to Weigh Losses for Scene Geometry and Semanticscited by 1,345
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,120
- 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 679
- 2020TAPAS: Weakly Supervised Table Parsing via Pre-trainingcited by 432
- 2019TabFact: A Large-scale Dataset for Table-based Fact Verificationcited by 425
- 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 420
- 2016Deep Biaffine Attention for Neural Dependency Parsingcited by 334
- 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
16 more
- 2019CoSQL: A Conversational Text-to-SQL Challenge Towards Cross-Domain Natural Language Interfaces to Databasescited by 180
- 2016Language to Logical Form with Neural Attentioncited by 158
- 2019SParC: Cross-Domain Semantic Parsing in Contextcited by 141
- 2017SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learningcited by 135
- 2018Coarse-to-Fine Decoding for Neural Semantic Parsingcited by 110
- 2017Learning a Neural Semantic Parser from User Feedbackcited by 98
- 2019A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualizationcited by 88
- 2018TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generationcited by 81
- 2020RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databasescited by 63
- 2018Robust Text-to-SQL Generation with Execution-Guided Decodingcited by 51
- 2018Simpler but More Accurate Semantic Dependency Parsingcited by 46
- 2020Hybrid Ranking Network for Text-to-SQLcited by 33
- 2020Program Enhanced Fact Verification with Verbalization and Graph Attention Networkcited by 29
- 2019X-SQL: reinforce schema representation with contextcited by 22
- 2018Semantic Parsing with Syntax- and Table-Aware SQL Generationcited by 17
- 2020Mention Extraction and Linking for SQL Query Generationcited by 9
Built on by
Citing papers per year: 2021: 3; 2022: 7; 2023: 5; 2024: 3; 2025: 4; 2026: 3.
25 papers.
Sort:
By area:
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsingcited by 30
- 2021SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoisingcited by 27
- 2024MAG-SQL: Multi-Agent Generative Approach with Soft Schema Linking and Iterative Sub-SQL Refinement for Text-to-SQLcited by 22
13 more
- 2025STaR-SQL: Self-Taught Reasoner for Text-to-SQLcited by 16
- 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parserscited by 7
- 2022Towards Generalizable and Robust Text-to-SQL Parsingcited by 7
- 2022Unveiling the Black Box of PLMs with Semantic Anchors: Towards Interpretable Neural Semantic Parsingcited by 5
- 2021Lyra: A Benchmark for Turducken-Style Code Generationcited by 4
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunitiescited by 4
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probescited by 2
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Taskscited by 1
- 2026Extending Confidence-Based Text2Cypher with Grammar and Schema Aware Filteringcited by 1
- 2023(Vector) Space is Not the Final Frontier: Product Search as Program Synthesiscited by 0
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decouplingcited by 0
- 2026The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactionscited by 0
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking processcited by 0
- 2026The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactions12 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026Extending Confidence-Based Text2Cypher with Grammar and Schema Aware Filtering11 May 2026
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes8 Jun 2025
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities28 May 2025
- 2025STaR-SQL: Self-Taught Reasoner for Text-to-SQL19 Feb 2025
- 2024MAG-SQL: Multi-Agent Generative Approach with Soft Schema Linking and Iterative Sub-SQL Refinement for Text-to-SQL15 Aug 2024
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL12 Jun 2024
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generation24 May 2024
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decoupling30 Jun 2023
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs4 May 2023
13 more
- 2023(Vector) Space is Not the Final Frontier: Product Search as Program Synthesis22 Apr 2023
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction21 Apr 2023
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsing18 Jan 2023
- 2022Towards Generalizable and Robust Text-to-SQL Parsing23 Oct 2022
- 2022Unveiling the Black Box of PLMs with Semantic Anchors: Towards Interpretable Neural Semantic Parsing4 Oct 2022
- 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parsers14 Sep 2022
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directions29 Aug 2022
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expect22 Aug 2022
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing28 Jun 2022
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parsers14 Mar 2022
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalization11 Sep 2021
- 2021Lyra: A Benchmark for Turducken-Style Code Generation27 Aug 2021
- 2021SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoising17 May 2021
- 2025STaR-SQL: Self-Taught Reasoner for Text-to-SQLcited by 16
- 2025STaR-SQL: Self-Taught Reasoner for Text-to-SQL19 Feb 2025
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsingcited by 30
- 2021SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoisingcited by 27
- 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parserscited by 7
12 most cited of 23 All 23 (JSON)
- 2026The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactions12 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026Extending Confidence-Based Text2Cypher with Grammar and Schema Aware Filtering11 May 2026
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes8 Jun 2025
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities28 May 2025
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL12 Jun 2024
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generation24 May 2024
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decoupling30 Jun 2023
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs4 May 2023
- 2023(Vector) Space is Not the Final Frontier: Product Search as Program Synthesis22 Apr 2023
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction21 Apr 2023
12 newest of 23 All 23 (JSON)