Semantic Parsing with Syntax- and Table-Aware SQL Generation
Not on the map. Why?
Abstract (arXiv)
We present a generative model to map natural language questions into SQL queries. Existing neural network based approaches typically generate a SQL query word-by-word, however, a large portion of the generated results are incorrect or not executable due to the mismatch between question words and table contents. Our approach addresses this problem by considering the structure of table and the syntax of SQL language. The quality of the generated SQL query is significantly improved through (1) learning to replicate content from column names, cells or SQL keywords; and (2) improving the generation of WHERE clause by leveraging the column-cell relation. Experiments are conducted on WikiSQL, a recently released dataset with the largest question-SQL pairs. Our approach significantly improves the state-of-the-art execution accuracy from 69.0% to 74.4%.
Key facts. Cited by 17 papers in the map (data through 7 Oct 2026). First posted on arXiv 23 Apr 2018.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 4; 2022: 3; 2023: 5; 2024: 2; 2025: 2; 2026: 1.
17 papers.
Sort:
By area:
- 2022A Survey on Table Question Answering: Recent Advancescited by 41
- 2023Data-Efficient Learning of Natural Language to Linear Temporal Logic Translators for Robot Task Specificationcited by 38
- 2021Data Augmentation with Hierarchical SQL-to-Question Generation for Cross-domain Text-to-SQL Parsingcited by 32
- 2021Improving Text-to-SQL with Schema Dependency Learningcited by 25
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQLcited by 20
- 2025Understanding, Detecting, and Repairing Real-World In-Context-Learning-Based Text-to-SQL Errorscited by 14
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Taskscited by 10
- 2023Marrying Dialogue Systems with Data Visualization: Interactive Data Visualization Generation from Natural Language Conversationscited by 9
- 2024End-to-end Text-to-SQL Generation within an Analytics Insight Enginecited by 7
- 2022Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Questioncited by 6
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQLcited by 5
- 2023On the Potential and Limitations of Few-Shot In-Context Learning to Generate Metamorphic Specifications for Tax Preparation Softwarecited by 3
5 more
- 2024ERATTA: Extreme RAG for Table To Answers with Large Language Modelscited by 1
- 2025JudgeSQL: Reasoning over SQL Candidates with Weighted Consensus Tournamentcited by 1
- 2026EvolSQL: Structure-Aware Evolution for Scalable Text-to-SQL Data Synthesiscited by 1
- 2021Self-supervised Text-to-SQL Learning with Header Alignment Trainingcited by 0
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decouplingcited by 0
- 2026EvolSQL: Structure-Aware Evolution for Scalable Text-to-SQL Data Synthesis8 Jan 2026
- 2025JudgeSQL: Reasoning over SQL Candidates with Weighted Consensus Tournament17 Oct 2025
- 2025Understanding, Detecting, and Repairing Real-World In-Context-Learning-Based Text-to-SQL Errors16 Jan 2025
- 2024End-to-end Text-to-SQL Generation within an Analytics Insight Engine17 Jun 2024
- 2024ERATTA: Extreme RAG for Table To Answers with Large Language Models7 May 2024
- 2023On the Potential and Limitations of Few-Shot In-Context Learning to Generate Metamorphic Specifications for Tax Preparation Software20 Nov 2023
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Tasks1 Oct 2023
- 2023Marrying Dialogue Systems with Data Visualization: Interactive Data Visualization Generation from Natural Language Conversations29 Jul 2023
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decoupling30 Jun 2023
- 2023Data-Efficient Learning of Natural Language to Linear Temporal Logic Translators for Robot Task Specification9 Mar 2023
- 2022A Survey on Table Question Answering: Recent Advances12 Jul 2022
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQL15 Mar 2022
5 more
- 2022Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Question4 Jan 2022
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQL16 Dec 2021
- 2021Self-supervised Text-to-SQL Learning with Header Alignment Training11 Mar 2021
- 2021Improving Text-to-SQL with Schema Dependency Learning7 Mar 2021
- 2021Data Augmentation with Hierarchical SQL-to-Question Generation for Cross-domain Text-to-SQL Parsing3 Mar 2021
- 2022A Survey on Table Question Answering: Recent Advancescited by 41
- 2023Data-Efficient Learning of Natural Language to Linear Temporal Logic Translators for Robot Task Specificationcited by 38
- 2021Data Augmentation with Hierarchical SQL-to-Question Generation for Cross-domain Text-to-SQL Parsingcited by 32
- 2021Improving Text-to-SQL with Schema Dependency Learningcited by 25
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQLcited by 20
- 2025Understanding, Detecting, and Repairing Real-World In-Context-Learning-Based Text-to-SQL Errorscited by 14
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Taskscited by 10
- 2023Marrying Dialogue Systems with Data Visualization: Interactive Data Visualization Generation from Natural Language Conversationscited by 9
- 2024End-to-end Text-to-SQL Generation within an Analytics Insight Enginecited by 7
- 2022Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Questioncited by 6
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQLcited by 5
- 2023On the Potential and Limitations of Few-Shot In-Context Learning to Generate Metamorphic Specifications for Tax Preparation Softwarecited by 3
12 most cited of 14 All 14 (JSON)
- 2025Understanding, Detecting, and Repairing Real-World In-Context-Learning-Based Text-to-SQL Errors16 Jan 2025
- 2024End-to-end Text-to-SQL Generation within an Analytics Insight Engine17 Jun 2024
- 2023On the Potential and Limitations of Few-Shot In-Context Learning to Generate Metamorphic Specifications for Tax Preparation Software20 Nov 2023
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Tasks1 Oct 2023
- 2023Marrying Dialogue Systems with Data Visualization: Interactive Data Visualization Generation from Natural Language Conversations29 Jul 2023
- 2023Feature Representation Learning for NL2SQL Generation Based on Coupling and Decoupling30 Jun 2023
- 2023Data-Efficient Learning of Natural Language to Linear Temporal Logic Translators for Robot Task Specification9 Mar 2023
- 2022A Survey on Table Question Answering: Recent Advances12 Jul 2022
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQL15 Mar 2022
- 2022Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Question4 Jan 2022
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQL16 Dec 2021
- 2021Self-supervised Text-to-SQL Learning with Header Alignment Training11 Mar 2021
12 newest of 14 All 14 (JSON)