mlsanityData to 14 Oct 2026

Grounding Natural Language to SQL Translation with Data-Based Self-Explanations

arXiv 2411.02948 ↗First posted 5 Nov 2024cs.DB cs.CLcited by 8

Not on the map. Why?

Abstract (arXiv)

Natural Language Interfaces for Databases empower non-technical users to interact with data using natural language (NL). Advanced approaches, utilizing either neural sequence-to-sequence or more recent sophisticated large-scale language models, typically implement NL to SQL (NL2SQL) translation in an end-to-end fashion. However, like humans, these end-to-end translation models may not always generate the best SQL output on their first try. In this paper, we propose CycleSQL, an iterative framework designed for end-to-end translation models to autonomously generate the best output through self-evaluation. The main idea of CycleSQL is to introduce data-grounded NL explanations of query results as self-provided feedback, and use the feedback to validate the correctness of the translation iteratively, hence improving the overall translation accuracy. Extensive experiments, including quantitative and qualitative evaluations, are conducted to study CycleSQL by applying it to seven existing translation models on five widely used benchmarks. The results show that 1) the feedback loop introduced in CycleSQL can consistently improve the performance of existing models, and in particular, by applying CycleSQL to RESDSQL, obtains a translation accuracy of 82.0% (+2.6%) on the validation set, and 81.6% (+3.2%) on the test set of Spider benchmark; 2) the generated NL explanations can also provide insightful information for users, aiding in the comprehension of translation results and consequently enhancing the interpretability of NL2SQL translation.

Key facts. Cited by 8 papers in the map (data through 14 Oct 2026). Builds on 46 of its 85 references that are in the map. First posted on arXiv 5 Nov 2024.

Builds on

46 of 85 references.

References · 46

  1. 2020Language Models are Few-Shot Learnerscited by 32,419
  2. 2023GPT-4 Technical Reportcited by 18,396
  3. 2022Training language models to follow instructions with human feedbackcited by 15,971
  4. 2019Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformercited by 14,599
  5. 2023LLaMA: Open and Efficient Foundation Language Modelscited by 14,132
  6. 2023Self-Refine: Iterative Refinement with Self-Feedbackcited by 3,442
  7. 2014Sequence to Sequence Learning with Neural Networkscited by 2,986
  8. 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,139
  9. 2023Teaching Large Language Models to Self-Debugcited by 988
  10. 2015Improving Neural Machine Translation Models with Monolingual Datacited by 788
  11. 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 687
  12. 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 477
34 more
  1. 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 424
  2. 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 411
  3. 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 385
  4. 2020Pretrained Transformers for Text Ranking: BERT and Beyondcited by 267
  5. 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
  6. 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 195
  7. 2020GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsingcited by 171
  8. 2024CHESS: Contextual Harnessing for Efficient SQL Synthesiscited by 169
  9. 2023C3: Zero-shot Text-to-SQL with ChatGPTcited by 164
  10. 2017SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learningcited by 135
  11. 2020Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsingcited by 133
  12. 2020Semantic Evaluation for Text-to-SQL with Distilled Test Suitescited by 126
  13. 2020Structure-Grounded Pretraining for Text-to-SQLcited by 126
  14. 2021Entailment as Few-Shot Learnercited by 123
  15. 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
  16. 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 119
  17. 2019Semantics-aware BERT for Language Understandingcited by 112
  18. 2021Towards Robustness of Text-to-SQL Models against Synonym Substitutioncited by 110
  19. 2022Evaluating the Text-to-SQL Capabilities of Large Language Modelscited by 101
  20. 2020SmBoP: Semi-autoregressive Bottom-up Semantic Parsingcited by 97
  21. 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
  22. 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
  23. 2020Feedback Loop and Bias Amplification in Recommender Systemscited by 90
  24. 2019Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsingcited by 74
  25. 2021Natural SQL: Making SQL Easier to Infer from Natural Language Specificationscited by 68
  26. 2023ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systemscited by 45
  27. 2024PURPLE: Making a Large Language Model a Better SQL Writercited by 34
  28. 2022Learning to Model Editing Processescited by 30
  29. 2023Interleaving Pre-Trained Language Models and Large Language Models for Zero-Shot NL2SQL Generationcited by 24
  30. 2017Deconvolving Feedback Loops in Recommender Systemscited by 17
  31. 2016Pre-Translation for Neural Machine Translationcited by 9
  32. 2022MIGA: A Unified Multi-task Generation Framework for Conversational Text-to-SQLcited by 5
  33. 2020Explaining Natural Language Query Resultscited by 2
  34. 2021Putting Things into Context: Rich Explanations for Query Answers using Join Graphs (extended version)cited by 2

Built on by

Cited by year (2026 to 14 Oct)

Citing papers per year: 2025: 3; 2026: 5.

8 papers.