RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databases
Not on the map. Why?
Abstract (arXiv)
Text-to-SQL is the problem of converting a user question into an SQL query, when the question and database are given. In this paper, we present a neural network approach called RYANSQL (Recursively Yielding Annotation Network for SQL) to solve complex Text-to-SQL tasks for cross-domain databases. State-ment Position Code (SPC) is defined to trans-form a nested SQL query into a set of non-nested SELECT statements; a sketch-based slot filling approach is proposed to synthesize each SELECT statement for its corresponding SPC. Additionally, two input manipulation methods are presented to improve generation performance further. RYANSQL achieved 58.2% accuracy on the challenging Spider benchmark, which is a 3.2%p improvement over previous state-of-the-art approaches. At the time of writing, RYANSQL achieves the first position on the Spider leaderboard.
Key facts. Cited by 63 papers in the map (data through 7 Oct 2026). First posted on arXiv 7 Apr 2020.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 12; 2022: 11; 2023: 9; 2024: 15; 2025: 13; 2026: 3.
63 papers.
Sort:
By area:
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2023C3: Zero-shot Text-to-SQL with ChatGPTcited by 159
- 2024CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQLcited by 132
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2022RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQLcited by 85
- 2024A Survey on Employing Large Language Models for Text-to-SQL Taskscited by 67
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2025OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignmentcited by 51
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2021Learning to Synthesize Data for Semantic Parsingcited by 41
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
38 more
- 2021ShadowGNN: Graph Projection Neural Network for Text-to-SQL Parsercited by 35
- 2024E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQLcited by 35
- 2021NL-EDIT: Correcting semantic parse errors through natural language interactioncited by 33
- 2024SQLBench: A Comprehensive Evaluation for Text-to-SQL Capabilities of Large Language Modelscited by 32
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsingcited by 30
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Surveycited by 27
- 2025LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQLcited by 26
- 2021Improving Text-to-SQL with Schema Dependency Learningcited by 25
- 2021Dual Reader-Parser on Hybrid Textual and Tabular Evidence for Open Domain Question Answeringcited by 25
- 2022Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graphcited by 22
- 2024MAG-SQL: Multi-Agent Generative Approach with Soft Schema Linking and Iterative Sub-SQL Refinement for Text-to-SQLcited by 22
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQLcited by 20
- 2022N-Best Hypotheses Reranking for Text-To-SQL Systemscited by 19
- 2025Reliable Text-to-SQL with Adaptive Abstentioncited by 19
- 2023Prompting GPT-3.5 for Text-to-SQL with De-semanticization and Skeleton Retrievalcited by 16
- 2023Retrieval-augmented GPT-3.5-based Text-to-SQL Framework with Sample-aware Prompting and Dynamic Revision Chaincited by 12
- 2023Evaluating Large Language Models for Health-related Queries with Presuppositionscited by 12
- 2022Deep Learning Driven Natural Languages Text to SQL Query Conversion: A Surveycited by 11
- 2024Structure Guided Large Language Model for SQL Generationcited by 9
- 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generationcited by 9
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructionscited by 8
- 2022Towards Generalizable and Robust Text-to-SQL Parsingcited by 7
- 2022Optimization Techniques for Unsupervised Complex Table Reasoning via Self-Training Frameworkcited by 6
- 2023Measuring and Mitigating Constraint Violations of In-Context Learning for Utterance-to-API Semantic Parsingcited by 6
- 2021An Investigation Between Schema Linking and Text-to-SQL Performancecited by 5
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunitiescited by 4
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translationcited by 3
- 2024Enhancing LLM Fine-tuning for Text-to-SQLs by SQL Quality Measurementcited by 3
- 2025Valid Text-to-SQL Generation with Unification-based DeepStochLogcited by 3
- 2024DeTriever: Decoder-representation-based Retriever for Improving NL2SQL In-Context Learningcited by 2
- 2024Towards Automated Cross-domain Exploratory Data Analysis through Large Language Modelscited by 2
- 2024SketchFill: Sketch-Guided Code Generation for Imputing Derived Missing Valuescited by 2
- 2025Feather-SQL: A Lightweight NL2SQL Framework with Dual-Model Collaboration Paradigm for Small Language Modelscited by 2
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probescited by 2
- 2025End-to-End Text-to-SQL with Dataset Selection: Leveraging LLMs for Adaptive Query Generationcited by 2
- 2021Turing: an Accurate and Interpretable Multi-Hypothesis Cross-Domain Natural Language Database Interfacecited by 1
- 2021End-to-End Cross-Domain Text-to-SQL Semantic Parsing with Auxiliary Taskcited by 1
- 2021Knowledge Graph Question Answering via SPARQL Silhouette Generationcited by 1
50 most cited of 63 All 63 (JSON)
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL4 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026Beyond Static Pipelines: Learning Dynamic Workflows for Text-to-SQL17 Feb 2026
- 2025Beyond SELECT: A Comprehensive Taxonomy-Guided Benchmark for Real-World Text-to-SQL Translation17 Nov 2025
- 2025GEMMA-SQL: A Novel Text-to-SQL Model Based on Large Language Models5 Nov 2025
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025End-to-End Text-to-SQL with Dataset Selection: Leveraging LLMs for Adaptive Query Generation8 Aug 2025
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes8 Jun 2025
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities28 May 2025
- 2025Domain Specific Question to SQL Conversion with Embedded Data Balancing Technique28 Mar 2025
- 2025LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQL24 Mar 2025
- 2025Feather-SQL: A Lightweight NL2SQL Framework with Dual-Model Collaboration Paradigm for Small Language Models22 Mar 2025
38 more
- 2025Valid Text-to-SQL Generation with Unification-based DeepStochLog17 Mar 2025
- 2025OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment19 Feb 2025
- 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generation18 Feb 2025
- 2025Reliable Text-to-SQL with Adaptive Abstention18 Jan 2025
- 2024SketchFill: Sketch-Guided Code Generation for Imputing Derived Missing Values26 Dec 2024
- 2024Towards Automated Cross-domain Exploratory Data Analysis through Large Language Models10 Dec 2024
- 2024Cooperative SQL Generation for Segmented Databases By Using Multi-functional LLM Agents8 Dec 2024
- 2024EzSQL: An SQL intermediate representation for improving SQL-to-text Generation28 Nov 2024
- 2024An Actor-Critic Approach to Boosting Text-to-SQL Large Language Model28 Oct 2024
- 2024CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL2 Oct 2024
- 2024Enhancing LLM Fine-tuning for Text-to-SQLs by SQL Quality Measurement2 Oct 2024
- 2024E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQL25 Sep 2024
- 2024MAG-SQL: Multi-Agent Generative Approach with Soft Schema Linking and Iterative Sub-SQL Refinement for Text-to-SQL15 Aug 2024
- 2024A Survey on Employing Large Language Models for Text-to-SQL Tasks21 Jul 2024
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL12 Jun 2024
- 2024DeTriever: Decoder-representation-based Retriever for Improving NL2SQL In-Context Learning12 Jun 2024
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructions21 Apr 2024
- 2024SQLBench: A Comprehensive Evaluation for Text-to-SQL Capabilities of Large Language Models5 Mar 2024
- 2024Structure Guided Large Language Model for SQL Generation19 Feb 2024
- 2023Evaluating Large Language Models for Health-related Queries with Presuppositions14 Dec 2023
- 2023Translating Natural Language Queries to SQL Using the T5 Model12 Dec 2023
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translation27 Oct 2023
- 2023Natural Language Interfaces for Tabular Data Querying and Visualization: A Survey27 Oct 2023
- 2023C3: Zero-shot Text-to-SQL with ChatGPT14 Jul 2023
- 2023Retrieval-augmented GPT-3.5-based Text-to-SQL Framework with Sample-aware Prompting and Dynamic Revision Chain11 Jul 2023
- 2023Measuring and Mitigating Constraint Violations of In-Context Learning for Utterance-to-API Semantic Parsing24 May 2023
- 2023Prompting GPT-3.5 for Text-to-SQL with De-semanticization and Skeleton Retrieval26 Apr 2023
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction21 Apr 2023
- 2022Optimization Techniques for Unsupervised Complex Table Reasoning via Self-Training Framework20 Dec 2022
- 2022Towards Generalizable and Robust Text-to-SQL Parsing23 Oct 2022
- 2022N-Best Hypotheses Reranking for Text-To-SQL Systems19 Oct 2022
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directions29 Aug 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
- 2022Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graph8 Aug 2022
- 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing28 Jun 2022
- 2022RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQL14 May 2022
- 2022UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQL15 Mar 2022
50 newest of 63 All 63 (JSON)
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2023C3: Zero-shot Text-to-SQL with ChatGPTcited by 159
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2022RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQLcited by 85
- 2024A Survey on Employing Large Language Models for Text-to-SQL Taskscited by 67
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2025OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignmentcited by 51
- 2022Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expectcited by 47
- 2021Learning to Synthesize Data for Semantic Parsingcited by 41
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2021ShadowGNN: Graph Projection Neural Network for Text-to-SQL Parsercited by 35
12 most cited of 59 All 59 (JSON)
- 2026Beyond Static Rules: Automated Discovery of Latent Vulnerabilities in Text-to-SQL4 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026Beyond Static Pipelines: Learning Dynamic Workflows for Text-to-SQL17 Feb 2026
- 2025Beyond SELECT: A Comprehensive Taxonomy-Guided Benchmark for Real-World Text-to-SQL Translation17 Nov 2025
- 2025GEMMA-SQL: A Novel Text-to-SQL Model Based on Large Language Models5 Nov 2025
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025End-to-End Text-to-SQL with Dataset Selection: Leveraging LLMs for Adaptive Query Generation8 Aug 2025
- 2025SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes8 Jun 2025
- 2025Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities28 May 2025
- 2025Domain Specific Question to SQL Conversion with Embedded Data Balancing Technique28 Mar 2025
- 2025LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQL24 Mar 2025
- 2025Feather-SQL: A Lightweight NL2SQL Framework with Dual-Model Collaboration Paradigm for Small Language Models22 Mar 2025
12 newest of 59 All 59 (JSON)