RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQL
Not on the map. Why?
Abstract (arXiv)
Relational structures such as schema linking and schema encoding have been validated as a key component to qualitatively translating natural language into SQL queries. However, introducing these structural relations comes with prices: they often result in a specialized model structure, which largely prohibits using large pretrained models in text-to-SQL. To address this problem, we propose RASAT: a Transformer seq2seq architecture augmented with relation-aware self-attention that could leverage a variety of relational structures while inheriting the pretrained parameters from the T5 model effectively. Our model can incorporate almost all types of existing relations in the literature, and in addition, we propose introducing co-reference relations for the multi-turn scenario. Experimental results on three widely used text-to-SQL datasets, covering both single-turn and multi-turn scenarios, have shown that RASAT could achieve state-of-the-art results across all three benchmarks (75.5% EX on Spider, 52.6% IEX on SParC, and 37.4% IEX on CoSQL).
Key facts. Cited by 85 papers in the map (data through 7 Oct 2026). Builds on 36 of its 44 references that are in the map. First posted on arXiv 14 May 2022.
Builds on
36 of 44 references.
References · 36
- 2017Attention Is All You Needcited by 59,932
- 2019Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformercited by 14,491
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,120
- 2018Self-Attention with Relative Position Representationscited by 1,112
- 2018Adafactor: Adaptive Learning Rates with Sublinear Memory Costcited by 896
- 2020Stanza: A Python Natural Language Processing Toolkit for Many Human Languagescited by 719
- 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 679
- 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
- 2022UnifiedSKG: Unifying and Multi-Tasking Structured Knowledge Grounding with Text-to-Text Language Modelscited by 231
- 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
- 2019CoSQL: A Conversational Text-to-SQL Challenge Towards Cross-Domain Natural Language Interfaces to Databasescited by 180
24 more
- 2020Compositional Generalization and Natural Language Variation: Can a Semantic Parsing Approach Handle Both?cited by 147
- 2019SParC: Cross-Domain Semantic Parsing in Contextcited by 141
- 2017SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learningcited by 135
- 2020Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsingcited by 133
- 2020Structure-Grounded Pretraining for Text-to-SQLcited by 126
- 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
- 2020Relational Graph Attention Network for Aspect-based Sentiment Analysiscited by 104
- 2020SmBoP: Semi-autoregressive Bottom-up Semantic Parsingcited by 97
- 2019A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualizationcited by 88
- 2018TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generationcited by 81
- 2019Editing-Based SQL Query Generation for Cross-Domain Context-Dependent Questionscited by 80
- 2020Grounded Adaptation for Zero-shot Executable Semantic Parsingcited by 76
- 2019Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsingcited by 74
- 2021Natural SQL: Making SQL Easier to Infer from Natural Language Specificationscited by 66
- 2020RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databasescited by 63
- 2018A Survey on Semantic Parsingcited by 62
- 2019Global Reasoning over Database Structures for Text-to-SQL Parsingcited by 43
- 2021SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQLcited by 43
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2020IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL Generationcited by 29
- 2022HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsingcited by 26
- 2019X-SQL: reinforce schema representation with contextcited by 22
- 2020Tracking Interaction States for Multi-Turn Text-to-SQL Semantic Parsingcited by 18
- 2021Pay More Attention to History: A Context Modelling Strategy for Conversational Text-to-SQLcited by 5
Built on by
Citing papers per year: 2022: 4; 2023: 31; 2024: 30; 2025: 13; 2026: 7.
85 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
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 378
- 2023StructGPT: A General Framework for Large Language Model to Reason over Structured Datacited by 339
- 2023LEVER: Learning to Verify Language-to-Code Generation with Executioncited by 228
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 191
- 2024CHESS: Contextual Harnessing for Efficient SQL Synthesiscited by 164
- 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 118
- 2024MCS-SQL: Leveraging Multiple Prompts and Multiple-Choice Selection For Text-to-SQL Generationcited by 103
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2023Exploring Chain-of-Thought Style Prompting for Text-to-SQLcited by 69
- 2023Is GPT-4 a Good Data Analyst?cited by 69
38 more
- 2024A Survey on Employing Large Language Models for Text-to-SQL Taskscited by 67
- 2023ACT-SQL: In-Context Learning for Text-to-SQL with Automatically-Generated Chain-of-Thoughtcited by 65
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMscited by 53
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
- 2023Skill-Based Few-Shot Selection for In-Context Learningcited by 46
- 2024DTS-SQL: Decomposed Text-to-SQL with Small Large Language Modelscited by 45
- 2023SQL-PaLM: Improved Large Language Model Adaptation for Text-to-SQL (extended)cited by 42
- 2024PURPLE: Making a Large Language Model a Better SQL Writercited by 34
- 2024SQLBench: A Comprehensive Evaluation for Text-to-SQL Capabilities of Large Language Modelscited by 32
- 2024StructLM: Towards Building Generalist Models for Structured Knowledge Groundingcited by 29
- 2022Importance of Synthesizing High-quality Data for Text-to-SQL Parsingcited by 27
- 2025LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQLcited by 26
- 2023Interleaving Pre-Trained Language Models and Large Language Models for Zero-Shot NL2SQL Generationcited by 24
- 2023Improving Generalization in Language Model-Based Text-to-SQL Semantic Parsing: Two Simple Semantic Boundary-Based Techniquescited by 23
- 2023Prompting GPT-3.5 for Text-to-SQL with De-semanticization and Skeleton Retrievalcited by 16
- 2023SQLPrompt: In-Context Text-to-SQL with Minimal Labeled Datacited by 16
- 2023UNITE: A Unified Benchmark for Text-to-SQL Evaluationcited by 14
- 2024CoE-SQL: In-Context Learning for Multi-Turn Text-to-SQL with Chain-of-Editionscited by 13
- 2023Retrieval-augmented GPT-3.5-based Text-to-SQL Framework with Sample-aware Prompting and Dynamic Revision Chaincited by 12
- 2024Using LLM to select the right SQL Query from candidatescited by 12
- 2024Evaluating the Data Model Robustness of Text-to-SQL Systems Based on Real User Queriescited by 12
- 2024TrustUQA: A Trustful Framework for Unified Structured Data Question Answeringcited by 12
- 2022CQR-SQL: Conversational Question Reformulation Enhanced Context-Dependent Text-to-SQL Parserscited by 11
- 2023Error Detection for Text-to-SQL Semantic Parsingcited by 11
- 2023Reboost Large Language Model-based Text-to-SQL, Text-to-Python, and Text-to-Function -- with Real Applications in Traffic Domaincited by 9
- 2024Structure Guided Large Language Model for SQL Generationcited by 9
- 2024A Survey of Large Language Model-Based Generative AI for Text-to-SQL: Benchmarks, Applications, Use Cases, and Challengescited by 9
- 2022NL2INTERFACE: Interactive Visualization Interface Generation from Natural Language Queriescited by 8
- 2023Adapt and Decompose: Efficient Generalization of Text-to-SQL via Domain Adapted Least-To-Most Promptingcited by 8
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructionscited by 8
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generationcited by 8
- 2024SQLfuse: Enhancing Text-to-SQL Performance through Comprehensive LLM Synergycited by 7
- 2024Unmasking Database Vulnerabilities: Zero-Knowledge Schema Inference Attacks in Text-to-SQL Systemscited by 6
- 2022MIGA: A Unified Multi-task Generation Framework for Conversational Text-to-SQLcited by 5
- 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Modelscited by 5
- 2024EHR-SeqSQL : A Sequential Text-to-SQL Dataset For Interactively Exploring Electronic Health Recordscited by 5
- 2025MTSQL-R1: Towards Long-Horizon Multi-Turn Text-to-SQL via Agentic Trainingcited by 5
50 most cited of 85 All 85 (JSON)
- 2026The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactions12 Jul 2026
- 2026STRATOS: Bridging the Symbolic-to-Numeric Gap in Spatio-Temporal Text-to-SQL for Meteorological Data3 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026SIRIUS-SQL: Anchoring Multi-Candidate Text-to-SQL in Execution Feedback31 May 2026
- 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Model13 May 2026
- 2026AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views8 Apr 2026
- 2026Track-SQL: Enhancing Generative Language Models with Dual-Extractive Modules for Schema and Context Tracking in Multi-turn Text-to-SQL6 Mar 2026
- 2025Bridging Global Intent with Local Details: A Hierarchical Representation Approach for Semantic Validation in Text-to-SQL28 Dec 2025
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generation26 Nov 2025
- 2025PuzLM: Solving Jigsaw Puzzles with Sequence-to-Sequence Language Models9 Nov 2025
- 2025MTSQL-R1: Towards Long-Horizon Multi-Turn Text-to-SQL via Agentic Training12 Oct 2025
- 2025STARE at the Structure: Steering ICL Exemplar Selection with Structural Alignment28 Aug 2025
38 more
- 2025Text to Query Plans for Question Answering on Large Tables26 Aug 2025
- 2025End-to-End Text-to-SQL with Dataset Selection: Leveraging LLMs for Adaptive Query Generation8 Aug 2025
- 2025HI-SQL: Optimizing Text-to-SQL Systems through Dynamic Hint Integration11 Jun 2025
- 2025StreamLink: Large-Language-Model Driven Distributed Data Engineering System27 May 2025
- 2025DCG-SQL: Enhancing In-Context Learning for Text-to-SQL with Deep Contextual Schema Link Graph26 May 2025
- 2025Abacus-SQL: A Text-to-SQL System Empowering Cross-Domain and Open-Domain Database Retrieval14 Apr 2025
- 2025LinkAlign: Scalable Schema Linking for Real-World Large-Scale Multi-Database Text-to-SQL24 Mar 2025
- 2025MultiTEND: A Multilingual Benchmark for Natural Language to NoSQL Query Translation16 Feb 2025
- 2024Can the Rookies Cut the Tough Cookie? Exploring the Use of LLMs for SQL Equivalence Checking7 Dec 2024
- 2024A Survey of Large Language Model-Based Generative AI for Text-to-SQL: Benchmarks, Applications, Use Cases, and Challenges6 Dec 2024
- 2024KeyInst: Keyword Instruction for Improving SQL Formulation in Text-to-SQL18 Oct 2024
- 2024Enhancing LLM Fine-tuning for Text-to-SQLs by SQL Quality Measurement2 Oct 2024
- 2024DataGpt-SQL-7B: An Open-Source Language Model for Text-to-SQL24 Sep 2024
- 2024Enhancing Text-to-SQL Capabilities of Large Language Models via Domain Database Knowledge Injection24 Sep 2024
- 2024SelECT-SQL: Self-correcting ensemble Chain-of-Thought for Text-to-SQL16 Sep 2024
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?9 Aug 2024
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMs6 Aug 2024
- 2024A Survey on Employing Large Language Models for Text-to-SQL Tasks21 Jul 2024
- 2024SQLfuse: Enhancing Text-to-SQL Performance through Comprehensive LLM Synergy19 Jul 2024
- 2024ETM: Modern Insights into Perspective on Text-to-SQL Evaluation in the Age of Large Language Models10 Jul 2024
- 2024TrustUQA: A Trustful Framework for Unified Structured Data Question Answering27 Jun 2024
- 2024Unmasking Database Vulnerabilities: Zero-Knowledge Schema Inference Attacks in Text-to-SQL Systems20 Jun 2024
- 2024RH-SQL: Refined Schema and Hardness Prompt for Text-to-SQL13 Jun 2024
- 2024CHESS: Contextual Harnessing for Efficient SQL Synthesis27 May 2024
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generation24 May 2024
- 2024EHR-SeqSQL : A Sequential Text-to-SQL Dataset For Interactively Exploring Electronic Health Records23 May 2024
- 2024KU-DMIS at EHRSQL 2024:Generating SQL query via question templatization in EHR22 May 2024
- 2024MCS-SQL: Leveraging Multiple Prompts and Multiple-Choice Selection For Text-to-SQL Generation13 May 2024
- 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Models4 May 2024
- 2024CoE-SQL: In-Context Learning for Multi-Turn Text-to-SQL with Chain-of-Editions4 May 2024
- 2024EPI-SQL: Enhancing Text-to-SQL Translation with Error-Prevention Instructions21 Apr 2024
- 2024PURPLE: Making a Large Language Model a Better SQL Writer29 Mar 2024
- 2024SQLBench: A Comprehensive Evaluation for Text-to-SQL Capabilities of Large Language Models5 Mar 2024
- 2024StructLM: Towards Building Generalist Models for Structured Knowledge Grounding26 Feb 2024
- 2024Structure Guided Large Language Model for SQL Generation19 Feb 2024
- 2024Evaluating the Data Model Robustness of Text-to-SQL Systems Based on Real User Queries13 Feb 2024
- 2024DTS-SQL: Decomposed Text-to-SQL with Small Large Language Models2 Feb 2024
- 2024Using LLM to select the right SQL Query from candidates4 Jan 2024
50 newest of 85 All 85 (JSON)
- 2023StructGPT: A General Framework for Large Language Model to Reason over Structured Datacited by 339
- 2023LEVER: Learning to Verify Language-to-Code Generation with Executioncited by 228
- 2023Exploring Chain-of-Thought Style Prompting for Text-to-SQLcited by 69
- 2023ACT-SQL: In-Context Learning for Text-to-SQL with Automatically-Generated Chain-of-Thoughtcited by 65
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generationcited by 8
- 2024SelECT-SQL: Self-correcting ensemble Chain-of-Thought for Text-to-SQLcited by 4
- 2025Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generation26 Nov 2025
- 2024SelECT-SQL: Self-correcting ensemble Chain-of-Thought for Text-to-SQL16 Sep 2024
- 2023ACT-SQL: In-Context Learning for Text-to-SQL with Automatically-Generated Chain-of-Thought26 Oct 2023
- 2023Exploring Chain-of-Thought Style Prompting for Text-to-SQL23 May 2023
- 2023StructGPT: A General Framework for Large Language Model to Reason over Structured Data16 May 2023
- 2023LEVER: Learning to Verify Language-to-Code Generation with Execution16 Feb 2023
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 465
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 378
- 2023RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLcited by 191
- 2024CHESS: Contextual Harnessing for Efficient SQL Synthesiscited by 164
- 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 118
- 2024MCS-SQL: Leveraging Multiple Prompts and Multiple-Choice Selection For Text-to-SQL Generationcited by 103
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2023Is GPT-4 a Good Data Analyst?cited by 69
- 2024A Survey on Employing Large Language Models for Text-to-SQL Taskscited by 67
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2024Synthesizing Text-to-SQL Data from Weak and Strong LLMscited by 53
12 most cited of 75 All 75 (JSON)
- 2026The Nuts and Bolts of Natural Language to SQL Translation: A Systematic Analysis of Model Pipeline Optimisation Approaches and their Interactions12 Jul 2026
- 2026STRATOS: Bridging the Symbolic-to-Numeric Gap in Spatio-Temporal Text-to-SQL for Meteorological Data3 Jul 2026
- 2026CHS-SQL: A Text-to-SQL approach based on Confidence-Guided Heuristic Search Schema Linking process17 Jun 2026
- 2026SIRIUS-SQL: Anchoring Multi-Candidate Text-to-SQL in Execution Feedback31 May 2026
- 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Model13 May 2026
- 2026Track-SQL: Enhancing Generative Language Models with Dual-Extractive Modules for Schema and Context Tracking in Multi-turn Text-to-SQL6 Mar 2026
- 2025Bridging Global Intent with Local Details: A Hierarchical Representation Approach for Semantic Validation in Text-to-SQL28 Dec 2025
- 2025PuzLM: Solving Jigsaw Puzzles with Sequence-to-Sequence Language Models9 Nov 2025
- 2025STARE at the Structure: Steering ICL Exemplar Selection with Structural Alignment28 Aug 2025
- 2025Text to Query Plans for Question Answering on Large Tables26 Aug 2025
- 2025End-to-End Text-to-SQL with Dataset Selection: Leveraging LLMs for Adaptive Query Generation8 Aug 2025
- 2025HI-SQL: Optimizing Text-to-SQL Systems through Dynamic Hint Integration11 Jun 2025
12 newest of 75 All 75 (JSON)