Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expect

08/22/2022
by   Naihao Deng, et al.
0

Text-to-SQL has attracted attention from both the natural language processing and database communities because of its ability to convert the semantics in natural language into SQL queries and its practical application in building natural language interfaces to database systems. The major challenges in text-to-SQL lie in encoding the meaning of natural utterances, decoding to SQL queries, and translating the semantics between these two forms. These challenges have been addressed to different extents by the recent advances. However, there is still a lack of comprehensive surveys for this task. To this end, we review recent progress on text-to-SQL for datasets, methods, and evaluation and provide this systematic survey, addressing the aforementioned challenges and discussing potential future directions. We hope that this survey can serve as quick access to existing work and motivate future research.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
08/29/2022

A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directions

Text-to-SQL parsing is an essential and challenging task. The goal of te...
research
04/19/2022

CodexDB: Generating Code for Processing SQL Queries using GPT-3 Codex

CodexDB is an SQL processing engine whose internals can be customized vi...
research
05/23/2023

Out-of-Distribution Generalization in Text Classification: Past, Present, and Future

Machine learning (ML) systems in natural language processing (NLP) face ...
research
12/26/2022

Natural Language Interfaces to Data

Recent advances in NLU and NLP have resulted in renewed interest in natu...
research
06/14/2023

SQL2Circuits: Estimating Metrics for SQL Queries with A Quantum Natural Language Processing Method

Quantum computing has developed significantly in recent years. Developin...
research
12/21/2020

MT-Teql: Evaluating and Augmenting Consistency of Text-to-SQL Models with Metamorphic Testing

Text-to-SQL is a task to generate SQL queries from human utterances. How...
research
06/09/2021

Text-to-SQL in the Wild: A Naturally-Occurring Dataset Based on Stack Exchange Data

Most available semantic parsing datasets, comprising of pairs of natural...

Please sign up or login with your details

Forgot password? Click here to reset