SQLucid: Grounding Natural Language Database Queries with Interactive Explanations
Not on the map. Why?
Abstract (arXiv)
Though recent advances in machine learning have led to significant improvements in natural language interfaces for databases, the accuracy and reliability of these systems remain limited, especially in high-stakes domains. This paper introduces SQLucid, a novel user interface that bridges the gap between non-expert users and complex database querying processes. SQLucid addresses existing limitations by integrating visual correspondence, intermediate query results, and editable step-by-step SQL explanations in natural language to facilitate user understanding and engagement. This unique blend of features empowers users to understand and refine SQL queries easily and precisely. Two user studies and one quantitative experiment were conducted to validate SQLucid's effectiveness, showing significant improvement in task completion accuracy and user confidence compared to existing interfaces. Our code is available at https://github.com/magic-YuanTian/SQLucid.
Key facts. Cited by 10 papers in the map (data through 7 Oct 2026). Builds on 31 of its 94 references that are in the map. First posted on arXiv 10 Sep 2024.
Builds on
31 of 94 references.
References · 31
- 2021Evaluating Large Language Models Trained on Codecited by 8,053
- 2022Self-Consistency Improves Chain of Thought Reasoning in Language Modelscited by 5,601
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,120
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 420
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2020Does the Whole Exceed its Parts? The Effect of AI Explanations on Complementary Team Performancecited by 396
- 2020Questioning the AI: Informing Design Practices for Explainable AI User Experiencescited by 251
- 2022Grounded Copilot: How Programmers Interact with Code-Generating Modelscited by 216
- 2017SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learningcited by 135
- 2017Learning a Neural Semantic Parser from User Feedbackcited by 98
- 2020SmBoP: Semi-autoregressive Bottom-up Semantic Parsingcited by 97
19 more
- 2019A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualizationcited by 88
- 2019Editing-Based SQL Query Generation for Cross-Domain Context-Dependent Questionscited by 80
- 2023"What It Wants Me To Say": Bridging the Abstraction Gap Between End-User Programmers and Code-Generating Large Language Modelscited by 48
- 2023RCOT: Detecting and Rectifying Factual Inconsistency in Reasoning by Reversing Chain-of-Thoughtcited by 47
- 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
- 2017Rationalization: A Neural Machine Translation Approach to Generating Natural Language Explanationscited by 37
- 2022Is a Question Decomposition Unit All We Need?cited by 37
- 2023LLMs as Factual Reasoners: Insights from Existing Benchmarks and Beyondcited by 37
- 2021NL-EDIT: Correcting semantic parse errors through natural language interactioncited by 33
- 2018SQL-to-Text Generation with Graph-to-Sequence Modelcited by 31
- 2019Generating Natural Language Explanations for Visual Question Answering using Scene Graphs and Visual Attentioncited by 26
- 2019Interactive Task and Concept Learning from Natural Language Instructions and GUI Demonstrationscited by 26
- 2017Automatic Generation of Natural Language Explanationscited by 22
- 2023Interactive Text-to-SQL Generation via Editable Step-by-Step Explanationscited by 19
- 2019Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databasescited by 15
- 2020"What Do You Mean by That?" A Parser-Independent Interactive Approach for Enhancing Text-to-SQLcited by 11
- 2019Overfitting in Synthesis: Theory and Practice (Extended Version)cited by 6
- 2020QueryVis: Logic-based diagrams help users understand complicated SQL queries fastercited by 4
Built on by
Citing papers per year: 2024: 1; 2025: 5; 2026: 4.
10 papers.
- 2025Human-AI Experience in Integrated Development Environments: A Systematic Literature Reviewcited by 5
- 2026PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agentscited by 5
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunitiescited by 4
- 2025M3: Conversational LLMs Simplify Secure Clinical Data Access, Understanding, and Analysiscited by 3
- 2025NeuroSync: Intent-Aware Code-Based Problem Solving via Direct LLM Understanding Modificationcited by 3
- 2025Interactive Program Synthesis for Modeling Collaborative Physical Activities from Narrated Demonstrationscited by 2
- 2026TACO: Task-Aware Column Description Generation Using LLMscited by 1
- 2024The Role of Accuracy and Validation Effectiveness in Conversational Business Analyticscited by 0
- 2026Bridging Natural Language and Interactive What-If Interfaces via LLM-Generated Declarative Specificationscited by 0
- 2026ISEE: Interactive Semantic Enrichment for Database Fieldscited by 0
- 2026TACO: Task-Aware Column Description Generation Using LLMs19 Jun 2026
- 2026ISEE: Interactive Semantic Enrichment for Database Fields21 Apr 2026
- 2026PV-SQL: Synergizing Database Probing and Rule-based Verification for Text-to-SQL Agents19 Apr 2026
- 2026Bridging Natural Language and Interactive What-If Interfaces via LLM-Generated Declarative Specifications8 Apr 2026
- 2025Interactive Program Synthesis for Modeling Collaborative Physical Activities from Narrated Demonstrations29 Sep 2025
- 2025NeuroSync: Intent-Aware Code-Based Problem Solving via Direct LLM Understanding Modification5 Aug 2025
- 2025M3: Conversational LLMs Simplify Secure Clinical Data Access, Understanding, and Analysis27 Jun 2025
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities28 May 2025
- 2025Human-AI Experience in Integrated Development Environments: A Systematic Literature Review8 Mar 2025
- 2024The Role of Accuracy and Validation Effectiveness in Conversational Business Analytics18 Nov 2024