Error Detection for Text-to-SQL Semantic Parsing

Shijie Chen, Ziru Chen, Huan Sun, Yu Su


Abstract
Despite remarkable progress in text-to-SQL semantic parsing in recent years, the performance of existing parsers is still far from perfect. Specifically, modern text-to-SQL parsers based on deep learning are often over-confident, thus casting doubt on their trustworthiness when deployed for real use. In this paper, we propose a parser-independent error detection model for text-to-SQL semantic parsing. Using a language model of code as its bedrock, we enhance our error detection model with graph neural networks that learn structural features of both natural language questions and SQL queries. We train our model on realistic parsing errors collected from a cross-domain setting, which leads to stronger generalization ability. Experiments with three strong text-to-SQL parsers featuring different decoding mechanisms show that our approach outperforms parser-dependent uncertainty metrics. Our model could also effectively improve the performance and usability of text-to-SQL semantic parsers regardless of their architectures.
Anthology ID:
2023.findings-emnlp.785
Volume:
Findings of the Association for Computational Linguistics: EMNLP 2023
Month:
December
Year:
2023
Address:
Singapore
Editors:
Houda Bouamor, Juan Pino, Kalika Bali
Venue:
Findings
SIG:
Publisher:
Association for Computational Linguistics
Note:
Pages:
11730–11743
Language:
URL:
https://aclanthology.org/2023.findings-emnlp.785
DOI:
10.18653/v1/2023.findings-emnlp.785
Bibkey:
Cite (ACL):
Shijie Chen, Ziru Chen, Huan Sun, and Yu Su. 2023. Error Detection for Text-to-SQL Semantic Parsing. In Findings of the Association for Computational Linguistics: EMNLP 2023, pages 11730–11743, Singapore. Association for Computational Linguistics.
Cite (Informal):
Error Detection for Text-to-SQL Semantic Parsing (Chen et al., Findings 2023)
Copy Citation:
PDF:
https://aclanthology.org/2023.findings-emnlp.785.pdf