Text-to-SQL Error Correction with Language Models of Code

05/22/2023

∙

Despite recent progress in text-to-SQL parsing, current semantic parsers are still not accurate enough for practical use. In this paper, we investigate how to build automatic text-to-SQL error correction models. Noticing that token-level edits are out of context and sometimes ambiguous, we propose building clause-level edit models instead. Besides, while most language models of code are not specifically pre-trained for SQL, they know common data structures and their operations in programming languages such as Python. Thus, we propose a novel representation for SQL queries and their edits that adheres more closely to the pre-training corpora of language models of code. Our error correction model improves the exact set match accuracy of different parsers by 2.4-6.5 and obtains up to 4.3 point absolute improvement over two strong baselines. Our code and data are available at https://github.com/OSU-NLP-Group/Auto-SQL-Correction.

READ FULL TEXT

Text-to-SQL Error Correction with Language Models of Code

PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models

Are Pre-trained Language Models Useful for Model Ensemble in Chinese Grammatical Error Correction?

Encoder-Decoder Models Can Benefit from Pre-trained Masked Language Models in Grammatical Error Correction

Numerically Grounded Language Models for Semantic Error Correction

Uncovering and Categorizing Social Biases in Text-to-SQL

Reference-less Measure of Faithfulness for Grammatical Error Correction

N-Best Hypotheses Reranking for Text-To-SQL Systems

Text-to-SQL Error Correction with Language Models of Code

Related Research

PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models

Are Pre-trained Language Models Useful for Model Ensemble in Chinese Grammatical Error Correction?

Encoder-Decoder Models Can Benefit from Pre-trained Masked Language Models in Grammatical Error Correction

Numerically Grounded Language Models for Semantic Error Correction

Uncovering and Categorizing Social Biases in Text-to-SQL

Reference-less Measure of Faithfulness for Grammatical Error Correction

N-Best Hypotheses Reranking for Text-To-SQL Systems