Text-to-SQL in the Wild: A Naturally-Occurring Dataset Based on Stack Exchange Data
Not on the map. Why?
Abstract (arXiv)
Most available semantic parsing datasets, comprising of pairs of natural utterances and logical forms, were collected solely for the purpose of training and evaluation of natural language understanding systems. As a result, they do not contain any of the richness and variety of natural-occurring utterances, where humans ask about data they need or are curious about. In this work, we release SEDE, a dataset with 12,023 pairs of utterances and SQL queries collected from real usage on the Stack Exchange website. We show that these pairs contain a variety of real-world challenges which were rarely reflected so far in any other semantic parsing dataset, propose an evaluation metric based on comparison of partial query clauses that is more suitable for real-world queries, and conduct experiments with strong baselines, showing a large gap between the performance on SEDE compared to other common datasets.
Key facts. Cited by 43 papers in the map (data through 7 Oct 2026). Builds on 18 of its 28 references that are in the map. First posted on arXiv 9 Jun 2021.
Builds on
18 of 28 references.
References · 18
- 2019Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformercited by 14,491
- 2018SentencePiece: A simple and language independent subword tokenizer and detokenizer for Neural Text Processingcited by 1,973
- 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
- 2015Compositional Semantic Parsing on Semi-Structured Tablescited by 509
- 2020TAPAS: Weakly Supervised Table Parsing via Pre-trainingcited by 432
- 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 420
- 2020GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsingcited by 171
- 2020Compositional Generalization and Natural Language Variation: Can a Semantic Parsing Approach Handle Both?cited by 147
- 2018Improving Text-to-SQL Evaluation Methodologycited by 133
- 2020Structure-Grounded Pretraining for Text-to-SQLcited by 126
- 2020Semantic Evaluation for Text-to-SQL with Distilled Test Suitescited by 123
6 more
- 2017Learning a Neural Semantic Parser from User Feedbackcited by 98
- 2020Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Trainingcited by 65
- 2020Speak to your Parser: Interactive Text-to-SQL with Natural Language Feedbackcited by 44
- 2019Model-based Interactive Semantic Parsing: A Unified Framework and A Text-to-SQL Case Studycited by 40
- 2021NL-EDIT: Correcting semantic parse errors through natural language interactioncited by 33
- 2014Type-Driven Incremental Semantic Parsing with Polymorphismcited by 4
Built on by
Citing papers per year: 2021: 1; 2022: 5; 2023: 12; 2024: 10; 2025: 12; 2026: 3.
43 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
- 2024Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflowscited by 223
- 2023Unifying the Perspectives of NLP and Software Engineering: A Survey on Language Models for Codecited by 62
- 2024Are LLMs Capable of Data-based Statistical and Causal Reasoning? Benchmarking Advanced Quantitative Reasoning with Datacited by 61
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2025DABstep: Data Agent Benchmark for Multi-step Reasoningcited by 44
- 2023EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Recordscited by 42
- 2023ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systemscited by 42
- 2022Prompt Injection: Parameterization of Fixed Inputscited by 35
- 2023Benchmarking and Improving Text-to-SQL Generation under Ambiguitycited by 31
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Surveycited by 27
31 more
- 2023CRUSH4SQL: Collective Retrieval Using Schema Hallucination For Text2SQLcited by 23
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactionscited by 17
- 2024TrustSQL: Benchmarking Text-to-SQL Reliability with Penalty-Based Scoringcited by 15
- 2025Towards LLM Agents for Earth Observationcited by 13
- 2024Evaluating the Data Model Robustness of Text-to-SQL Systems Based on Real User Queriescited by 12
- 2022Deep Learning Driven Natural Languages Text to SQL Query Conversion: A Surveycited by 11
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Taskscited by 10
- 2024Vi(E)va LLM! A Conceptual Stack for Evaluating and Interpreting Generative AI-based Visualizationscited by 10
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domaincited by 10
- 2025Tabular Data Understanding with LLMs: A Survey of Recent Advances and Challengescited by 10
- 2025Sparks of Tabular Reasoning via Text2SQL Reinforcement Learningcited by 9
- 2022Diverse Parallel Data Synthesis for Cross-Database Adaptation of Text-to-SQL Parserscited by 7
- 2023FormaT5: Abstention and Examples for Conditional Table Formatting with Natural Languagecited by 7
- 2024EHR-SeqSQL : A Sequential Text-to-SQL Dataset For Interactively Exploring Electronic Health Recordscited by 5
- 2025STRuCT-LLM: Unifying Tabular and Graph Reasoning with Reinforcement Learning for Semantic Parsingcited by 5
- 2024Improving Generalization in Semantic Parsing by Increasing Natural Language Variationcited by 4
- 2025RubikSQL: Lifelong Learning Agentic Knowledge Base as an Industrial NL2SQL Systemcited by 4
- 2022A Survey on Artificial Intelligence for Source Code: A Dialogue Systems Perspectivecited by 3
- 2023Structured Case-based Reasoning for Inference-time Adaptation of Text-to-SQL parserscited by 3
- 2024Towards Unbiased Evaluation of Detecting Unanswerable Questions in EHRSQLcited by 3
- 2025Conversational Lexicography: Querying Lexicographic Data on Knowledge Graphs with SPARQL through Natural Languagecited by 3
- 2021Prefix-to-SQL: Text-to-SQL Generation from Incomplete User Questionscited by 2
- 2023Semantic Parsing for Complex Data Retrieval: Targeting Query Plans vs. SQL for No-Code Access to Relational Databasescited by 1
- 2025REFORMER: A ChatGPT-Driven Data Synthesis Framework Elevating Text-to-SQL Modelscited by 1
- 2025FinStat2SQL: A Text2SQL Pipeline for Financial Statement Analysiscited by 1
- 2025SQLSpace: A Representation Space for Text-to-SQL to Discover and Mitigate Robustness Gapscited by 1
- 2026Schema-First Retrieval: Embedding Catalogs for Natural Language Analyticscited by 1
- 2023Domain Adaptation of a State of the Art Text-to-SQL Model: Lessons Learned and Challenges Foundcited by 0
- 2025Multi-Dimensional Summarization Agents with Context-Aware Reasoning over Enterprise Tablescited by 0
- 2026Natural Language Interfaces for Spatial and Temporal Databases: A Comprehensive Overview of Methods, Taxonomy, and Future Directionscited by 0
- 2026Debiasing Without Protected Attributes: Latent Concept Erasure from Textual Profilescited by 0
- 2026Schema-First Retrieval: Embedding Catalogs for Natural Language Analytics23 Jun 2026
- 2026Debiasing Without Protected Attributes: Latent Concept Erasure from Textual Profiles10 Jun 2026
- 2026Natural Language Interfaces for Spatial and Temporal Databases: A Comprehensive Overview of Methods, Taxonomy, and Future Directions24 Mar 2026
- 2025SQLSpace: A Representation Space for Text-to-SQL to Discover and Mitigate Robustness Gaps31 Oct 2025
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions6 Oct 2025
- 2025RubikSQL: Lifelong Learning Agentic Knowledge Base as an Industrial NL2SQL System25 Aug 2025
- 2025Multi-Dimensional Summarization Agents with Context-Aware Reasoning over Enterprise Tables10 Aug 2025
- 2025Tabular Data Understanding with LLMs: A Survey of Recent Advances and Challenges31 Jul 2025
- 2025DABstep: Data Agent Benchmark for Multi-step Reasoning30 Jun 2025
- 2025FinStat2SQL: A Text2SQL Pipeline for Financial Statement Analysis29 Jun 2025
- 2025STRuCT-LLM: Unifying Tabular and Graph Reasoning with Reinforcement Learning for Semantic Parsing15 Jun 2025
- 2025Conversational Lexicography: Querying Lexicographic Data on Knowledge Graphs with SPARQL through Natural Language26 May 2025
31 more
- 2025Sparks of Tabular Reasoning via Text2SQL Reinforcement Learning23 Apr 2025
- 2025Towards LLM Agents for Earth Observation16 Apr 2025
- 2025REFORMER: A ChatGPT-Driven Data Synthesis Framework Elevating Text-to-SQL Models6 Apr 2025
- 2024Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflows12 Nov 2024
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?9 Aug 2024
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domain12 Jun 2024
- 2024EHR-SeqSQL : A Sequential Text-to-SQL Dataset For Interactively Exploring Electronic Health Records23 May 2024
- 2024Towards Unbiased Evaluation of Detecting Unanswerable Questions in EHRSQL29 Apr 2024
- 2024TrustSQL: Benchmarking Text-to-SQL Reliability with Penalty-Based Scoring23 Mar 2024
- 2024Are LLMs Capable of Data-based Statistical and Causal Reasoning? Benchmarking Advanced Quantitative Reasoning with Data27 Feb 2024
- 2024Improving Generalization in Semantic Parsing by Increasing Natural Language Variation13 Feb 2024
- 2024Evaluating the Data Model Robustness of Text-to-SQL Systems Based on Real User Queries13 Feb 2024
- 2024Vi(E)va LLM! A Conceptual Stack for Evaluating and Interpreting Generative AI-based Visualizations3 Feb 2024
- 2023Semantic Parsing for Complex Data Retrieval: Targeting Query Plans vs. SQL for No-Code Access to Relational Databases22 Dec 2023
- 2023Domain Adaptation of a State of the Art Text-to-SQL Model: Lessons Learned and Challenges Found9 Dec 2023
- 2023Unifying the Perspectives of NLP and Software Engineering: A Survey on Language Models for Code14 Nov 2023
- 2023CRUSH4SQL: Collective Retrieval Using Schema Hallucination For Text2SQL2 Nov 2023
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Survey27 Oct 2023
- 2023FormaT5: Abstention and Examples for Conditional Table Formatting with Natural Language26 Oct 2023
- 2023Benchmarking and Improving Text-to-SQL Generation under Ambiguity20 Oct 2023
- 2023Testing the Limits of Unified Sequence to Sequence LLM Pretraining on Diverse Table Data Tasks1 Oct 2023
- 2023ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems7 Jun 2023
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs4 May 2023
- 2023EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Records16 Jan 2023
- 2023Structured Case-based Reasoning for Inference-time Adaptation of Text-to-SQL parsers10 Jan 2023
- 2022Diverse Parallel Data Synthesis for Cross-Database Adaptation of Text-to-SQL Parsers29 Oct 2022
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expect22 Aug 2022
- 2022Deep Learning Driven Natural Languages Text to SQL Query Conversion: A Survey8 Aug 2022
- 2022Prompt Injection: Parameterization of Fixed Inputs31 May 2022
- 2022A Survey on Artificial Intelligence for Source Code: A Dialogue Systems Perspective10 Feb 2022
- 2021Prefix-to-SQL: Text-to-SQL Generation from Incomplete User Questions15 Sep 2021
- 2024Are LLMs Capable of Data-based Statistical and Causal Reasoning? Benchmarking Advanced Quantitative Reasoning with Datacited by 61
- 2025DABstep: Data Agent Benchmark for Multi-step Reasoningcited by 44
- 2025Sparks of Tabular Reasoning via Text2SQL Reinforcement Learningcited by 9
- 2025STRuCT-LLM: Unifying Tabular and Graph Reasoning with Reinforcement Learning for Semantic Parsingcited by 5
- 2025Multi-Dimensional Summarization Agents with Context-Aware Reasoning over Enterprise Tablescited by 0
- 2025Multi-Dimensional Summarization Agents with Context-Aware Reasoning over Enterprise Tables10 Aug 2025
- 2025DABstep: Data Agent Benchmark for Multi-step Reasoning30 Jun 2025
- 2025STRuCT-LLM: Unifying Tabular and Graph Reasoning with Reinforcement Learning for Semantic Parsing15 Jun 2025
- 2025Sparks of Tabular Reasoning via Text2SQL Reinforcement Learning23 Apr 2025
- 2024Are LLMs Capable of Data-based Statistical and Causal Reasoning? Benchmarking Advanced Quantitative Reasoning with Data27 Feb 2024
- 2022Prompt Injection: Parameterization of Fixed Inputscited by 35
- 2022Prompt Injection: Parameterization of Fixed Inputs31 May 2022
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2024Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflowscited by 223
- 2023Unifying the Perspectives of NLP and Software Engineering: A Survey on Language Models for Codecited by 62
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2023EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Recordscited by 42
- 2023ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systemscited by 42
- 2023Benchmarking and Improving Text-to-SQL Generation under Ambiguitycited by 31
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Surveycited by 27
- 2023CRUSH4SQL: Collective Retrieval Using Schema Hallucination For Text2SQLcited by 23
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactionscited by 17
- 2024TrustSQL: Benchmarking Text-to-SQL Reliability with Penalty-Based Scoringcited by 15
12 most cited of 34 All 34 (JSON)
- 2026Schema-First Retrieval: Embedding Catalogs for Natural Language Analytics23 Jun 2026
- 2026Debiasing Without Protected Attributes: Latent Concept Erasure from Textual Profiles10 Jun 2026
- 2026Natural Language Interfaces for Spatial and Temporal Databases: A Comprehensive Overview of Methods, Taxonomy, and Future Directions24 Mar 2026
- 2025SQLSpace: A Representation Space for Text-to-SQL to Discover and Mitigate Robustness Gaps31 Oct 2025
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions6 Oct 2025
- 2025FinStat2SQL: A Text2SQL Pipeline for Financial Statement Analysis29 Jun 2025
- 2025Conversational Lexicography: Querying Lexicographic Data on Knowledge Graphs with SPARQL through Natural Language26 May 2025
- 2025Towards LLM Agents for Earth Observation16 Apr 2025
- 2025REFORMER: A ChatGPT-Driven Data Synthesis Framework Elevating Text-to-SQL Models6 Apr 2025
- 2024Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflows12 Nov 2024
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?9 Aug 2024
- 2024BookSQL: A Large Scale Text-to-SQL Dataset for Accounting Domain12 Jun 2024
12 newest of 34 All 34 (JSON)