Enhancing SQL Table Acquisition with Reverse Engineering for Text-to-SQL (2025.findings-emnlp)
Copied to clipboard
| Challenge: | Text-to-SQL oriented table acquisition suffers from heterogeneous semantic gap. |
| Approach: | They propose a Reverse Engineering based table acquisition approach that reversely generates potentially-matched questions conditioned on table schemas instead of forward table search using queries. |
| Outcome: | The proposed approach achieves competitive performance on two benchmarks, including SpiderUnion and BirdUnion. |
Similar Papers
Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expect (2022.coling-1)
Copied to clipboard
| Challenge: | text-to-SQL is a language processing and database-based language processing (NLP) task is to convert natural utterances into SQL queries and its practical application is to build natural language interfaces to database systems. |
| Approach: | They propose to conduct a systematic survey of text-to-SQL to examine the challenges and potential future directions. |
| Outcome: | The proposed system converts natural utterances into SQL queries and is a representative task in semantic parsing. |
Gen-SQL: Efficient Text-to-SQL By Bridging Natural Language Question And Database Schema With Pseudo-Schema (2025.coling-main)
Copied to clipboard
| Challenge: | Recent studies have shifted paradigms and leveraged Large Language Models (LLMs) to tackle the challenging task of Text-to-SQL. |
| Approach: | They propose a framework that leverages large language models to generate SQL queries . they exploit prior knowledge from the LLM to enhance embedding-based retriever . |
| Outcome: | The proposed method improves embedding-based retriever and reduces cost. |
Text-to-Table: A New Way of Information Extraction (2022.acl-long)
Copied to clipboard
| Challenge: | Existing methods for information extraction are not well understood . text-to-table is a problem that aims to extract information from text data . |
| Approach: | They propose a new problem setting of information extraction, called text-to-table . they formalize text- to-table as a sequence-tosequence problem . |
| Outcome: | The proposed method outperforms existing methods on text-to-table tasks. |
ReEx-SQL: Reasoning with Execution-Aware Reinforcement Learning for Text-to-SQL (2026.acl-long)
Copied to clipboard
Yaxun Dai, Wenxuan Xie, Xialie Zhuang, Tianyu Yang, Ziyi Liu, Haiqin Yang, Yiying Yang, Yuhang Zhao, Pingfu Chao, Wenhao Jiang
| Challenge: | Current Text-to-SQL reasoning models lack integrated execution feedback during generation. |
| Approach: | They propose a text-to-SQL framework that interacts with the SQL execution engine during decoding and dynamically adjusts reasoning based on execution feedback. |
| Outcome: | The proposed framework achieves 89.1% accuracy on Spider and 65.3% on BIRD at the 7B scale. |
R3-SQL: Ranking Reward and Resampling for Text-to-SQL (2026.findings-acl)
Copied to clipboard
| Challenge: | Existing rankers assign inconsistent scores to functionally equivalent SQL queries . ranking cannot recover when the correct SQL is absent from the pool. |
| Approach: | They propose a Text-to-SQL framework that rewards ranking and resampling . it first groups candidates by execution result and ranks groups for consistency . |
| Outcome: | The proposed framework achieves 75.03 execution accuracy on BIRD-dev, a new state of the art among methods using models with disclosed sizes. |
Is Table Retrieval a Solved Problem? Exploring Join-Aware Multi-Table Retrieval (2024.acl-long)
Copied to clipboard
| Challenge: | Existing methods for retrieving relevant tables are not sufficient as many questions require retrieving multiple tables and joining them through a join plan that cannot be discerned from the user query itself. |
| Approach: | They propose a method that uncovers useful join relations during table retrieval. |
| Outcome: | The proposed method outperforms the state-of-the-art methods for table retrieval by up to 9.3% in F1 score and for end-to-end QA by up 5.4% in accuracy. |
REaR : Retrieve, Expand and Refine for Effective Multitable Retrieval (2026.acl-long)
Copied to clipboard
| Challenge: | REaR is retriever-agnostic and improves dense/ sparse retrievers on complex table QA datasets. |
| Approach: | a new framework separates semantic relevance from structural joinability for efficient multi-table retrieval. adam scott and eric liu introduce REaR, a three-stage, LLM-free framework. |
| Outcome: | a new framework improves retrieval quality and performance on complex table QA datasets . it separates semantic relevance from structural joinability and prunes weakly related candidates . the framework is retriever-agnostic and delivers performance competitive with state-of-the-art LLM-augmented retrieval systems . |
Rethinking Schema Linking: A Context-Aware Bidirectional Retrieval Approach for Text-to-SQL (2026.findings-eacl)
Copied to clipboard
| Challenge: | Recent methods focus on improving SQL generation but neglect retrieval of relevant schema elements. |
| Approach: | They propose a context-aware bidirectional schema retrieval framework that treats schema linking as a standalone problem. |
| Outcome: | The proposed framework improves schema recall while reducing false positives. |
Improving Retrieval-augmented Text-to-SQL with AST-based Ranking and Schema Pruning (2024.emnlp-main)
Copied to clipboard
| Challenge: | Existing methods for text-to-SQL semantic parsing are limited to retrieving schemata based on a single query. |
| Approach: | They propose a text-to-sql semantic parser that uses abstract syntax trees to select few-shot examples for retrieval-augmented generation. |
| Outcome: | The proposed model can generate approximated versions of SQL queries in parallel, and shows improvements over state-of-the-art benchmarks. |
Tailoring Table Retrieval from a Field-aware Hybrid Matching Perspective (2025.emnlp-main)
Copied to clipboard
| Challenge: | Empirical results show that a hybrid retrieval approach to table retrieval outperforms state-of-the-art benchmarks. |
| Approach: | They propose a table-tailored HYbrid matching rEtriever which addresses table matching needs from a field-aware hybrid perspective. |
| Outcome: | Empirical results show that the proposed rEtriever outperforms state-of-the-art retrieval methods. |