Error Detection for Text-to-SQL Semantic Parsing
Not on the map. Why?
Abstract (arXiv)
Despite remarkable progress in text-to-SQL semantic parsing in recent years, the performance of existing parsers is still far from perfect. Specifically, modern text-to-SQL parsers based on deep learning are often over-confident, thus casting doubt on their trustworthiness when deployed for real use. In this paper, we propose a parser-independent error detection model for text-to-SQL semantic parsing. Using a language model of code as its bedrock, we enhance our error detection model with graph neural networks that learn structural features of both natural language questions and SQL queries. We train our model on realistic parsing errors collected from a cross-domain setting, which leads to stronger generalization ability. Experiments with three strong text-to-SQL parsers featuring different decoding mechanisms show that our approach outperforms parser-dependent uncertainty metrics. Our model could also effectively improve the performance and usability of text-to-SQL semantic parsers regardless of their architectures. (Our implementation is available at https://github.com/OSU-NLP-Group/Text2SQL-Error-Detection)
Key facts. Cited by 12 papers in the map (data through 14 Oct 2026). Builds on 24 of its 38 references that are in the map. First posted on arXiv 23 May 2023.
Builds on
24 of 38 references.
References · 24
- 2020CodeBERT: A Pre-Trained Model for Programming and Natural Languagescited by 1,310
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,139
- 2021How Attentive are Graph Attention Networks?cited by 835
- 2020Stanza: A Python Natural Language Processing Toolkit for Many Human Languagescited by 723
- 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 424
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 411
- 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 195
- 2020GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsingcited by 171
- 2020Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsingcited by 133
- 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
- 2021KaggleDBQA: Realistic Evaluation of Text-to-SQL Parserscited by 106
12 more
- 2020SmBoP: Semi-autoregressive Bottom-up Semantic Parsingcited by 97
- 2022RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQLcited by 85
- 2021Natural SQL: Making SQL Easier to Infer from Natural Language Specificationscited by 68
- 2019Global Reasoning over Database Structures for Text-to-SQL Parsingcited by 43
- 2019Model-based Interactive Semantic Parsing: A Unified Framework and A Text-to-SQL Case Studycited by 40
- 2022Towards Robustness of Text-to-SQL Models Against Natural and Realistic Adversarial Table Perturbationcited by 28
- 2020Photon: A Robust Cross-Domain Text-to-SQL Systemcited by 26
- 2020An Imitation Game for Learning Semantic Parsers from User Interactioncited by 23
- 2023Text-to-SQL Error Correction with Language Models of Codecited by 21
- 2020Bertrand-DR: Improving Text-to-SQL using a Discriminative Re-rankercited by 12
- 2020"What Do You Mean by That?" A Parser-Independent Interactive Approach for Enhancing Text-to-SQLcited by 11
- 2022T5QL: Taming language models for SQL generationcited by 8
Built on by
Citing papers per year: 2023: 1; 2024: 1; 2025: 5; 2026: 5.
12 papers.
- 2024When is Tree Search Useful for LLM Planning? It Depends on the Discriminatorcited by 47
- 2025SQLens: An End-to-End Framework for Error Detection and Correction in Text-to-SQLcited by 12
- 2025Confidence Estimation for Error Detection in Text-to-SQL Systemscited by 11
- 2025Can LLMs Narrate Tabular Data? An Evaluation Framework for Natural Language Representations of Text-to-SQL System Outputscited by 7
- 2025Calibrating LLMs for Text-to-SQL Parsing by Leveraging Sub-clause Frequenciescited by 5
- 2026Semantic Layers for Reliable LLM-Powered Data Analytics: A Paired Benchmark of Accuracy and Hallucination Across Three Frontier Modelscited by 3
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinementcited by 2
- 2023Predicting generalization performance with correctness discriminatorscited by 1
- 2025Bridging Global Intent with Local Details: A Hierarchical Representation Approach for Semantic Validation in Text-to-SQLcited by 0
- 2026CLARA: Clarification of Language Ambiguity through Result Analysis for Natural-Language Cancer Genomics Queriescited by 0
- 2026Certified Against Which Oracle? Execution Labels Set the Reported Risk of Conformal Abstention for Text-to-SQLcited by 0
- 2026Why, Where, How: Taxonomy-guided Error Grounding for Code Repair in NL2SQLcited by 0
- 2026Why, Where, How: Taxonomy-guided Error Grounding for Code Repair in NL2SQL4 Oct 2026
- 2026Certified Against Which Oracle? Execution Labels Set the Reported Risk of Conformal Abstention for Text-to-SQL22 Sep 2026
- 2026CLARA: Clarification of Language Ambiguity through Result Analysis for Natural-Language Cancer Genomics Queries3 Aug 2026
- 2026Semantic Layers for Reliable LLM-Powered Data Analytics: A Paired Benchmark of Accuracy and Hallucination Across Three Frontier Models28 Apr 2026
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinement4 Mar 2026
- 2025Bridging Global Intent with Local Details: A Hierarchical Representation Approach for Semantic Validation in Text-to-SQL28 Dec 2025
- 2025Can LLMs Narrate Tabular Data? An Evaluation Framework for Natural Language Representations of Text-to-SQL System Outputs27 Oct 2025
- 2025SQLens: An End-to-End Framework for Error Detection and Correction in Text-to-SQL4 Jun 2025
- 2025Calibrating LLMs for Text-to-SQL Parsing by Leveraging Sub-clause Frequencies27 May 2025
- 2025Confidence Estimation for Error Detection in Text-to-SQL Systems16 Jan 2025
- 2024When is Tree Search Useful for LLM Planning? It Depends on the Discriminator16 Feb 2024
- 2023Predicting generalization performance with correctness discriminators15 Nov 2023