Text-To-SQL
134 papers with code • 6 benchmarks • 14 datasets
Text-to-SQL is a task in natural language processing (NLP) where the goal is to automatically generate SQL queries from natural language text. The task involves converting the text input into a structured representation and then using this representation to generate a semantically correct SQL query that can be executed on a database.
( Image credit: SyntaxSQLNet )
Benchmarks
These leaderboards are used to track progress in Text-To-SQL
| Trend | Dataset | Best Model | Paper | Code | Compare |
|---|---|---|---|---|---|
|
|||||
|
|||||
|
|||||
|
|||||
|
|||||
|
Libraries
Use these libraries to find Text-To-SQL models and implementationsDatasets
Spider-Realistic
SParC
CoSQL
KaggleDBQA
SEDE
MultiSpider
Latest papers with no code
Multi-Hop Table Retrieval for Open-Domain Text-to-SQL
To reduce the effect of the similar irrelevant entity, our method focuses on unretrieved entities at each hop and considers the low-ranked tables by beam search.
Improving Demonstration Diversity by Human-Free Fusing for Text-to-SQL
Currently, the in-context learning method based on large language models (LLMs) has become the mainstream of text-to-SQL research.
Evaluating the Data Model Robustness of Text-to-SQL Systems Based on Real User Queries
All of our data is based on real user questions that were asked live to the system.
Investigating the Impact of Data Contamination of Large Language Models in Text-to-SQL Translation
Our results indicate a significant performance drop in GPT-3. 5 on the unfamiliar Termite dataset, even with ATD modifications, highlighting the effect of Data Contamination on LLMs in Text-to-SQL translation tasks.
DTS-SQL: Decomposed Text-to-SQL with Small Large Language Models
Leading models for the text-to-SQL task heavily rely on proprietary Large Language Models (LLMs), posing concerns over data privacy.
FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis
Text-to-SQL, which provides zero-code interface for operating relational databases, has gained much attention in financial analysis; because, financial professionals may not well-skilled in SQL programming.
Using LLM to select the right SQL Query from candidates
We propose an automatic test case generation method that first generates a database and then uses LLMs to predict the ground truth, which is the expected execution results of the ground truth SQL query on this database.
Semantic Parsing for Complex Data Retrieval: Targeting Query Plans vs. SQL for No-Code Access to Relational Databases
In this paper, we investigate the potential of an alternative query language with simpler syntax and modular specification of complex queries.
Data Transformation to Construct a Dataset for Generating Entity-Relationship Model from Natural Language
To address this issue, in this paper, we report our insight that there exists a high similarity between the task of NL2ERM and the increasingly popular task of text-to-SQL, and propose a data transformation algorithm that transforms the existing data of text-to-SQL into the data of NL2ERM.
dIR -- Discrete Information Retrieval: Conversational Search over Unstructured (and Structured) Data with Large Language Models
This paper introduces dIR, Discrete Information Retrieval, providing a unified interface to query both free text and structured knowledge.
