SHARE: An SLM-based Hierarchical Action CorREction Assistant for Text-to-SQL
On the map: LLM reasoning → Knowledge- and tool-augmented reasoning
Abstract (arXiv)
Current self-correction approaches in text-to-SQL face two critical limitations: 1) Conventional self-correction methods rely on recursive self-calls of LLMs, resulting in multiplicative computational overhead, and 2) LLMs struggle to implement effective error detection and correction for declarative SQL queries, as they fail to demonstrate the underlying reasoning path. In this work, we propose SHARE, an SLM-based Hierarchical Action corREction assistant that enables LLMs to perform more precise error localization and efficient correction. SHARE orchestrates three specialized Small Language Models (SLMs) in a sequential pipeline, where it first transforms declarative SQL queries into stepwise action trajectories that reveal underlying reasoning, followed by a two-phase granular refinement. We further propose a novel hierarchical self-evolution strategy for data-efficient training. Experimental results demonstrate that SHARE effectively enhances self-correction capabilities while proving robust across various LLMs. Furthermore, our comprehensive analysis shows that SHARE maintains strong performance even in low-resource training settings, which is particularly valuable for text-to-SQL applications with data privacy constraints.
Key facts. Cited by 16 papers in the map (data through 14 Oct 2026). Placed in Knowledge- and tool-augmented reasoning, one of 17 directions in LLM reasoning. Builds on 38 of its 49 references that are in the map. First posted on arXiv 31 May 2025.
Builds on
38 of 49 references.
Closest ancestors · 3
Same direction, newest first
- 2024CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL2 Oct
- 2024Decomposition for Enhancing Attention: Improving LLM-based Text-to-SQL through Workflow Paradigm16 Feb
- 2024A Survey of Table Reasoning with Large Language Models13 Feb
Other references · 35
- 2022Training language models to follow instructions with human feedbackcited by 15,971
- 2023Direct Preference Optimization: Your Language Model is Secretly a Reward Modelcited by 8,065
- 2020Scaling Laws for Neural Language Modelscited by 6,586
- 2022Self-Consistency Improves Chain of Thought Reasoning in Language Modelscited by 5,708
- 2024LlamaFactory: Unified Efficient Fine-Tuning of 100+ Language Modelscited by 1,464
- 2023Mind2Web: Towards a Generalist Agent for the Webcited by 1,242
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,139
- 2023Large Language Models Cannot Self-Correct Reasoning Yetcited by 1,017
- 2023Teaching Large Language Models to Self-Debugcited by 988
- 2023CRITIC: Large Language Models Can Self-Correct with Tool-Interactive Critiquingcited by 783
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 688
- 2020Pre-trained Models for Natural Language Processing: A Surveycited by 505
23 more
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 477
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 385
- 2022CodeT: Code Generation with Generated Testscited by 384
- 2024Is DPO Superior to PPO for LLM Alignment? A Comprehensive Studycited by 262
- 2024CHESS: Contextual Harnessing for Efficient SQL Synthesiscited by 169
- 2023MAC-SQL: A Multi-Agent Collaborative Framework for Text-to-SQLcited by 164
- 2021Neural Path Hunter: Reducing Hallucination in Dialogue Systems via Path Groundingcited by 106
- 2024MCS-SQL: Leveraging Multiple Prompts and Multiple-Choice Selection For Text-to-SQL Generationcited by 105
- 2020Overcoming Catastrophic Forgetting in Graph Neural Networkscited by 95
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2025ChartCoder: Advancing Multimodal Large Language Model for Chart-to-Code Generationcited by 92
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 50
- 2024Middleware for LLMs: Tools Are Instrumental for Language Agents in Complex Environmentscited by 39
- 2024MAGIC: Generating Self-Correction Guideline for In-Context Text-to-SQLcited by 35
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQLcited by 20
- 2024Tapilot-Crossing: Benchmarking and Evolving LLMs Towards Interactive Data Analysis Agentscited by 17
- 2024SM3-Text-to-Query: Synthetic Multi-Model Medical Text-to-Query Benchmarkcited by 14
- 2022Non-Programmers Can Label Programs Indirectly via Active Examples: A Case Study with Text-to-SQLcited by 12
- 2024Using LLM to select the right SQL Query from candidatescited by 12
- 2024Enhancing Knowledge Distillation of Large Language Models through Efficient Multi-Modal Distribution Alignmentcited by 11
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructionscited by 8
- 2024R3: "This is My SQL, Are You With Me?" A Consensus-Based Multi-Agent System for Text-to-SQL Taskscited by 7
Built on by
Citing papers per year: 2025: 4; 2026: 12.
16 papers.
Sort:
By area:
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactionscited by 19
- 2025SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applicationscited by 16
- 2025MARS-SQL: A multi-agent reinforcement learning framework for Text-to-SQLcited by 15
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generationcited by 10
- 2026Memo-SQL: Structured Decomposition and Experience-Driven Self-Correction for Training-Free NL2SQLcited by 4
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinementcited by 2
- 2026Human-Level Text-to-SQL via Reinforcement Learning on Verified Data, Without Pipeline Engineeringcited by 1
- 2026EGREFINE: An Execution-Grounded Optimization Framework for Text-to-SQL Schema Refinementcited by 1
- 2026SemanticAgent: A Semantics-Aware Framework for Text-to-SQL Data Synthesiscited by 0
- 2026LEAF-SQL: Level-wise Exploration with Adaptive Fine-graining for Text-to-SQL Skeleton Predictioncited by 0
- 2026CAPER: Clause-Aligned Process Supervision for Text-to-SQLcited by 0
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQLcited by 0
4 more
- 2026Are These Modules Worth Their Cost? A Paradigm-Level Accuracy-Cost Analysis of In-context Learning Text-to-SQLcited by 0
- 2026BIRD-History: A Benchmark for History-Driven Text-to-SQL with Fine-Grained Knowledge Annotationscited by 0
- 2026COAL-SQL: Coverage-Guided Augmentation and Failure-Driven Learning for Text-to-SQL Post-Trainingcited 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
- 2026BIRD-History: A Benchmark for History-Driven Text-to-SQL with Fine-Grained Knowledge Annotations29 Aug 2026
- 2026Are These Modules Worth Their Cost? A Paradigm-Level Accuracy-Cost Analysis of In-context Learning Text-to-SQL28 Aug 2026
- 2026COAL-SQL: Coverage-Guided Augmentation and Failure-Driven Learning for Text-to-SQL Post-Training4 Aug 2026
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL4 Jul 2026
- 2026CAPER: Clause-Aligned Process Supervision for Text-to-SQL2 Jun 2026
- 2026LEAF-SQL: Level-wise Exploration with Adaptive Fine-graining for Text-to-SQL Skeleton Prediction10 May 2026
- 2026EGREFINE: An Execution-Grounded Optimization Framework for Text-to-SQL Schema Refinement1 May 2026
- 2026SemanticAgent: A Semantics-Aware Framework for Text-to-SQL Data Synthesis23 Apr 2026
- 2026Human-Level Text-to-SQL via Reinforcement Learning on Verified Data, Without Pipeline Engineering20 Mar 2026
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinement4 Mar 2026
- 2026Memo-SQL: Structured Decomposition and Experience-Driven Self-Correction for Training-Free NL2SQL15 Jan 2026
4 more
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generation26 Nov 2025
- 2025MARS-SQL: A multi-agent reinforcement learning framework for Text-to-SQL2 Nov 2025
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions6 Oct 2025
- 2025SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications23 Jun 2025
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactionscited by 19
- 2025SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applicationscited by 16
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinementcited by 2
- 2026EGREFINE: An Execution-Grounded Optimization Framework for Text-to-SQL Schema Refinementcited by 1
- 2026SemanticAgent: A Semantics-Aware Framework for Text-to-SQL Data Synthesiscited by 0
- 2026LEAF-SQL: Level-wise Exploration with Adaptive Fine-graining for Text-to-SQL Skeleton Predictioncited by 0
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQLcited by 0
- 2026Are These Modules Worth Their Cost? A Paradigm-Level Accuracy-Cost Analysis of In-context Learning Text-to-SQLcited by 0
- 2026BIRD-History: A Benchmark for History-Driven Text-to-SQL with Fine-Grained Knowledge Annotationscited by 0
- 2026COAL-SQL: Coverage-Guided Augmentation and Failure-Driven Learning for Text-to-SQL Post-Trainingcited 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
- 2026BIRD-History: A Benchmark for History-Driven Text-to-SQL with Fine-Grained Knowledge Annotations29 Aug 2026
- 2026Are These Modules Worth Their Cost? A Paradigm-Level Accuracy-Cost Analysis of In-context Learning Text-to-SQL28 Aug 2026
- 2026COAL-SQL: Coverage-Guided Augmentation and Failure-Driven Learning for Text-to-SQL Post-Training4 Aug 2026
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL4 Jul 2026
- 2026LEAF-SQL: Level-wise Exploration with Adaptive Fine-graining for Text-to-SQL Skeleton Prediction10 May 2026
- 2026EGREFINE: An Execution-Grounded Optimization Framework for Text-to-SQL Schema Refinement1 May 2026
- 2026SemanticAgent: A Semantics-Aware Framework for Text-to-SQL Data Synthesis23 Apr 2026
- 2026ErrorLLM: Modeling SQL Errors for Text-to-SQL Refinement4 Mar 2026
- 2025BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions6 Oct 2025
- 2025SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications23 Jun 2025
Similar, not cited
Close in wording, no citation either way
- 2026ACTS-SQL: Agentic and Critic-Oriented Tree-Structured SQL Correctness with Large Language Models
- 2025SLM-SQL: An Exploration of Small Language Models for Text-to-SQL
- 2025SQLCritic: Correcting Text-to-SQL Generation via Clause-wise Critic
- 2025CSC-SQL: Corrective Self-Consistency in Text-to-SQL via Reinforcement Learning
- 2025RetrySQL: text-to-SQL training with retry data for self-correcting query generation
- 2024Tool-Assisted Agent on SQL Inspection and Refinement in Real-World Scenarios
- 2025SPFT-SQL: Enhancing Large Language Model for Text-to-SQL Parsing by Self-Play Fine-Tuning
- 2025SQL-of-Thought: Multi-agentic Text-to-SQL with Guided Error Correction