Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Training
Not on the map. Why?
Abstract (arXiv)
Most recently, there has been significant interest in learning contextual representations for various NLP tasks, by leveraging large scale text corpora to train large neural language models with self-supervised learning objectives, such as Masked Language Model (MLM). However, based on a pilot study, we observe three issues of existing general-purpose language models when they are applied to text-to-SQL semantic parsers: fail to detect column mentions in the utterances, fail to infer column mentions from cell values, and fail to compose complex SQL queries. To mitigate these issues, we present a model pre-training framework, Generation-Augmented Pre-training (GAP), that jointly learns representations of natural language utterances and table schemas by leveraging generation models to generate pre-train data. GAP MODEL is trained on 2M utterance-schema pairs and 30K utterance-schema-SQL triples, whose utterances are produced by generative models. Based on experimental results, neural semantic parsers that leverage GAP MODEL as a representation encoder obtain new state-of-the-art results on both SPIDER and CRITERIA-TO-SQL benchmarks.
Key facts. Cited by 65 papers in the map (data through 7 Oct 2026). First posted on arXiv 18 Dec 2020.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 19; 2022: 21; 2023: 13; 2024: 10; 2025: 2.
65 papers.
Sort:
By area:
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2021TAPEX: Table Pre-training via Learning a Neural SQL Executorcited by 233
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 191
- 2024CodeS: Towards Building Open-source Language Models for Text-to-SQLcited by 183
- 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2021Natural SQL: Making SQL Easier to Infer from Natural Language Specificationscited by 66
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMscited by 53
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2021Text-to-SQL in the Wild: A Naturally-Occurring Dataset Based on Stack Exchange Datacited by 43
- 2021SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQLcited by 43
38 more
- 2022Table Pre-training: A Survey on Model Architectures, Pre-training Objectives, and Downstream Taskscited by 42
- 2023EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Recordscited by 42
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2023On Robustness of Prompt-based Semantic Parsing with Large Pre-trained Language Model: An Empirical Study on Codexcited by 41
- 2021Data Augmentation with Hierarchical SQL-to-Question Generation for Cross-domain Text-to-SQL Parsingcited by 32
- 2022XRICL: Cross-lingual Retrieval-Augmented In-Context Learning for Cross-lingual Text-to-SQL Semantic Parsingcited by 32
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsingcited by 30
- 2022OmniTab: Pretraining with Natural and Synthetic Data for Few-shot Table-based Question Answeringcited by 29
- 2022ReasTAP: Injecting Table Reasoning Skills During Pre-training via Synthetic Reasoning Examplescited by 29
- 2022Importance of Synthesizing High-quality Data for Text-to-SQL Parsingcited by 27
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Surveycited by 27
- 2022HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsingcited by 26
- 2021Dual Reader-Parser on Hybrid Textual and Tabular Evidence for Open Domain Question Answeringcited by 25
- 2021Structure-aware Fine-tuning of Sequence-to-sequence Transformers for Transition-based AMR Parsingcited by 25
- 2023Improving Generalization in Language Model-Based Text-to-SQL Semantic Parsing: Two Simple Semantic Boundary-Based Techniquescited by 23
- 2022Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graphcited by 22
- 2023Divide and Prompt: Chain of Thought Prompting for Text-to-SQLcited by 20
- 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsingcited by 19
- 2024Metasql: A Generate-then-Rank Framework for Natural Language to SQL Translationcited by 17
- 2022Measuring and Improving Compositional Generalization in Text-to-SQL via Component Alignmentcited by 16
- 2022PLOG: Table-to-Logic Pretraining for Logical Table-to-Text Generationcited by 16
- 2021mRAT-SQL+GAP:A Portuguese Text-to-SQL Transformercited by 15
- 2021Decoupled Dialogue Modeling and Semantic Parsing for Multi-Turn Text-to-SQLcited by 13
- 2021Hierarchical Neural Data Synthesis for Semantic Parsingcited by 11
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domaincited by 10
- 2021Relation Aware Semi-autoregressive Semantic Parsing for NL2SQLcited by 8
- 2022T5QL: Taming language models for SQL generationcited by 8
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructionscited by 8
- 2024Generalists vs. Specialists: Evaluating LLMs on Highly-Constrained Biophysical Sequence Optimization Taskscited by 8
- 2021SPARQLing Database Queries from Intermediate Question Decompositionscited by 7
- 2022Diverse Parallel Data Synthesis for Cross-Database Adaptation of Text-to-SQL Parserscited by 7
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQLcited by 5
- 2022Unveiling the Black Box of PLMs with Semantic Anchors: Towards Interpretable Neural Semantic Parsingcited by 5
- 2022Improving Cross-task Generalization of Unified Table-to-text Models with Compositional Task Configurationscited by 3
- 2023A Multilingual Translator to SQL with Database Schema Pruning to Improve Self-Attentioncited by 3
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translationcited by 3
- 2021Prefix-to-SQL: Text-to-SQL Generation from Incomplete User Questionscited by 2
- 2022Integrating question answering and text-to-SQL in Portuguesecited by 2
50 most cited of 65 All 65 (JSON)
- 2025REFORMER: A ChatGPT-Driven Data Synthesis Framework Elevating Text-to-SQL Models6 Apr 2025
- 2025What Really Matters for Table LLMs? A Meta-Evaluation of Model and Data Effects24 Jan 2025
- 2024EzSQL: An SQL intermediate representation for improving SQL-to-text Generation28 Nov 2024
- 2024Generalists vs. Specialists: Evaluating LLMs on Highly-Constrained Biophysical Sequence Optimization Tasks29 Oct 2024
- 2024Enhancing Text-to-SQL Capabilities of Large Language Models via Domain Database Knowledge Injection24 Sep 2024
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMs6 Aug 2024
- 2024RH-SQL: Refined Schema and Hardness Prompt for Text-to-SQL13 Jun 2024
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domain12 Jun 2024
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructions21 Apr 2024
- 2024Schema-Aware Multi-Task Learning for Complex Text-to-SQL9 Mar 2024
- 2024Metasql: A Generate-then-Rank Framework for Natural Language to SQL Translation27 Feb 2024
- 2024CodeS: Towards Building Open-source Language Models for Text-to-SQL26 Feb 2024
38 more
- 2023Decoupling SQL Query Hardness Parsing for Text-to-SQL11 Dec 2023
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translation27 Oct 2023
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Survey27 Oct 2023
- 2023Natural language to SQL in low-code platforms29 Aug 2023
- 2023Structural Transfer Learning in NL-to-Bash Semantic Parsers31 Jul 2023
- 2023A Multilingual Translator to SQL with Database Schema Pruning to Improve Self-Attention25 Jun 2023
- 2023T5-SR: A Unified Seq-to-Seq Decoding Strategy for Semantic Parsing14 Jun 2023
- 2023Improving Generalization in Language Model-Based Text-to-SQL Semantic Parsing: Two Simple Semantic Boundary-Based Techniques27 May 2023
- 2023Towards Multi-Modal DBMSs for Seamless Querying of Texts and Tables26 Apr 2023
- 2023Divide and Prompt: Chain of Thought Prompting for Text-to-SQL23 Apr 2023
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL12 Feb 2023
- 2023On Robustness of Prompt-based Semantic Parsing with Large Pre-trained Language Model: An Empirical Study on Codex30 Jan 2023
- 2023EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Records16 Jan 2023
- 2022Importance of Synthesizing High-quality Data for Text-to-SQL Parsing17 Dec 2022
- 2022Improving Cross-task Generalization of Unified Table-to-text Models with Compositional Task Configurations17 Dec 2022
- 2022Diverse Parallel Data Synthesis for Cross-Database Adaptation of Text-to-SQL Parsers29 Oct 2022
- 2022XRICL: Cross-lingual Retrieval-Augmented In-Context Learning for Cross-lingual Text-to-SQL Semantic Parsing25 Oct 2022
- 2022ReasTAP: Injecting Table Reasoning Skills During Pre-training via Synthetic Reasoning Examples22 Oct 2022
- 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsing21 Oct 2022
- 2022AskYourDB: An end-to-end system for querying and visualizing relational databases using natural language16 Oct 2022
- 2022Unveiling the Black Box of PLMs with Semantic Anchors: Towards Interpretable Neural Semantic Parsing4 Oct 2022
- 2022T5QL: Taming language models for SQL generation21 Sep 2022
- 2022The BLue Amazon Brain (BLAB): A Modular Architecture of Services about the Brazilian Maritime Territory6 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
- 2022Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graph8 Aug 2022
- 2022OmniTab: Pretraining with Natural and Synthetic Data for Few-shot Table-based Question Answering8 Jul 2022
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing28 Jun 2022
- 2022PLOG: Table-to-Logic Pretraining for Logical Table-to-Text Generation25 May 2022
- 2022Measuring and Improving Compositional Generalization in Text-to-SQL via Component Alignment4 May 2022
- 2022HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsing14 Mar 2022
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parsers14 Mar 2022
- 2022Integrating question answering and text-to-SQL in Portuguese8 Feb 2022
- 2022Table Pre-training: A Survey on Model Architectures, Pre-training Objectives, and Downstream Tasks24 Jan 2022
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQL16 Dec 2021
- 2021Hierarchical Neural Data Synthesis for Semantic Parsing4 Dec 2021
- 2021Linking-Enhanced Pre-Training for Table Semantic Parsing18 Nov 2021
- 2021SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQL1 Nov 2021
50 newest of 65 All 65 (JSON)
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2021TAPEX: Table Pre-training via Learning a Neural SQL Executorcited by 233
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 191
- 2024CodeS: Towards Building Open-source Language Models for Text-to-SQLcited by 183
- 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2021Natural SQL: Making SQL Easier to Infer from Natural Language Specificationscited by 66
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMscited by 53
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2021Text-to-SQL in the Wild: A Naturally-Occurring Dataset Based on Stack Exchange Datacited by 43
- 2021SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQLcited by 43
12 most cited of 60 All 60 (JSON)
- 2025REFORMER: A ChatGPT-Driven Data Synthesis Framework Elevating Text-to-SQL Models6 Apr 2025
- 2025What Really Matters for Table LLMs? A Meta-Evaluation of Model and Data Effects24 Jan 2025
- 2024EzSQL: An SQL intermediate representation for improving SQL-to-text Generation28 Nov 2024
- 2024Generalists vs. Specialists: Evaluating LLMs on Highly-Constrained Biophysical Sequence Optimization Tasks29 Oct 2024
- 2024Enhancing Text-to-SQL Capabilities of Large Language Models via Domain Database Knowledge Injection24 Sep 2024
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMs6 Aug 2024
- 2024RH-SQL: Refined Schema and Hardness Prompt for Text-to-SQL13 Jun 2024
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domain12 Jun 2024
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructions21 Apr 2024
- 2024Schema-Aware Multi-Task Learning for Complex Text-to-SQL9 Mar 2024
- 2024Metasql: A Generate-then-Rank Framework for Natural Language to SQL Translation27 Feb 2024
- 2024CodeS: Towards Building Open-source Language Models for Text-to-SQL26 Feb 2024
12 newest of 60 All 60 (JSON)