SeqGenSQL – A Robust Sequence Generation Model for Structured Query Language

11/07/2020
by   Ning Li, et al.
2

We explore using T5 (Raffel et al. (2019)) to directly translate natural language questions into SQL statements. General purpose natural language that interfaces to information stored within databases requires flexibly translating natural language questions into database queries. The best performing text-to-SQL systems approach this task by first converting questions into an intermediate logical form (LF) (Lyu et al. (2020)). While LFs provide a convenient intermediate representation and simplify query generation, they introduce an additional layer of complexity and annotation requirements. However, weakly supervised modeling that directly converts questions to SQL statements has proven more difficult without the scaffolding provided by LFs (Min et al. (2019)). We approach direct conversion of questions to SQL statements using T5 (Raffel et al. (2019)), a pre-trained textto-text generation model, modified to support pointer-generator style decoding (See et al. (2017)). We explore using question augmentation with table schema information and the use of automatically generated silver training data. The resulting model achieves 90.5 (2017)) test data set, a new state-of-the-art on weakly supervised SQL generation. The performance improvement is 6.6 state-of-the-art (Min et al. (2019)) and approaches the performance of state-ofthe-art systems making use of LFs.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
09/13/2021

SPARQLing Database Queries from Intermediate Question Decompositions

To translate natural language questions into executable database queries...
research
12/17/2022

Know What I don't Know: Handling Ambiguous and Unanswerable Questions for Text-to-SQL

The task of text-to-SQL is to convert a natural language question to its...
research
04/18/2021

Flexible Operations for Natural Language Deduction

An interpretable system for complex, open-domain reasoning needs an inte...
research
05/10/2023

SPSQL: Step-by-step Parsing Based Framework for Text-to-SQL Generation

Converting text into the structured query language (Text2SQL) is a resea...
research
01/04/2022

Speech-to-SQL: Towards Speech-driven SQL Query Generation From Natural Language Question

Speech-based inputs have been gaining significant momentum with the popu...
research
10/19/2020

ColloQL: Robust Cross-Domain Text-to-SQL Over Search Queries

Translating natural language utterances to executable queries is a helpf...
research
06/21/2015

Extreme Extraction: Only One Hour per Relation

Information Extraction (IE) aims to automatically generate a large knowl...

Please sign up or login with your details

Forgot password? Click here to reset