RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQL

05/14/2022
by   Jiexing Qi, et al.
0

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 the use of 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 at the meantime being able to effectively inherit the pretrained parameters from the T5 model. Our model is able to incorporate almost all types of existing relations in the literature, and in addition, we propose to introduce 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 competitive results in all three benchmarks, achieving state-of-the-art performance in execution accuracy (80.5% EX on Spider, 53.1% IEX on SParC, and 37.5% IEX on CoSQL).

READ FULL TEXT

page 1

page 2

page 3

page 4

research
11/10/2019

RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers

When translating natural language questions into SQL queries to answer q...
research
05/11/2023

QURG: Question Rewriting Guided Context-Dependent Text-to-SQL Semantic Parsing

Context-dependent Text-to-SQL aims to translate multi-turn natural langu...
research
06/28/2022

Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing

The importance of building text-to-SQL parsers which can be applied to n...
research
03/15/2022

UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQL

Existing text-to-SQL semantic parsers are typically designed for particu...
research
02/21/2023

Conversational Text-to-SQL: An Odyssey into State-of-the-Art and Challenges Ahead

Conversational, multi-turn, text-to-SQL (CoSQL) tasks map natural langua...
research
06/27/2019

Encoding Database Schemas with Relation-Aware Self-Attention for Text-to-SQL Parsers

When translating natural language questions into SQL queries to answer q...
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...

Please sign up or login with your details

Forgot password? Click here to reset