arrow
Return

EMLC: An extensible multi-level correction framework for text-to-SQL

delete2025-12-18
delete0
PRE
AI
雷
雷建军 (Jianjun Lei)
Y
Yijie Tan
Y
Ying Wang
DOI:10.1016/j.ipm.2025.104560delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
To address three key challenges of Text-to-SQL self-correction, including schema mismatch, structural incompleteness, and semantic validation weakness, this paper proposes EMLC, an extensible multi-level correction framework that hierarchically integrates schema, skeleton, and execution corrections. EMLC incorporates a dual-validation schema correction mechanism that combines large language model (LLM)-based prediction with token-level mapping for precise schema alignment. Moreover, it employs supervised fine-tuning skeleton generation to detect and correct keyword-level errors through abstract skeleton comparison, while the executability verification strategy is designed to further ensure both syntactic integrity and semantic fidelity of generated queries. EMLC supports plug-and-play integration with mainstream LLMs and flexible scalability. Experiments on the SPIDER and BIRD datasets show that EMLC achieves state-of-the-art execution accuracy, outperforming baseline methods by 2–4 %. Ablation studies further validate the individual contributions of each component and their synergistic effects.

Journal

I
Information Processing and Management
IF:
6.9
Papers:
5.2K
Citations:
1.4W

Organization

C
Chongqing University of Posts and Telecommunications
Scholars:
2.5K
Papers: 980
Citations: 3.8K
Cited Papers

Cited Papers

A survey on deep learning approaches for text-to-SQL
err2023-01-23
err0
errOAAI
errGeorge Katsogiannis-Meimarakis; Georgia Koutrika
errShare
errSave
Graph-empowered Text-to-SQL generation on Electronic Medical Records
err2026-01-01
err0
PREAI
errChen,Qian; Peng,Jun; Song,Baiyang; Zhou,Yiyi; Ji,Rongrong
errShare
errSave
Benchmarking large language models for biomedical natural language processing applications and recommendations
err2025-04-06
err2
errOAAI
errChen, Qingyu; Hu, Yan; Peng, Xueqing; Xie, Qianqian; Jin, Qiao; Gilson, Aidan; Singer, Maxwell B.; Ai, Xuguang; Lai, Po-Ting; Wang, Zhizheng; Keloth, Vipina K.; Raja, Kalpana; Huang, Jimin; He, Huan; Lin, Fongci; Du, Jingcheng; Zhang, Rui; Zheng, W. Jim; Adelman, Ron A.
errShare
errSave
SCoT2S: Self-correcting Text-to-SQL parsing by leveraging LLMs
err2025-07-31
err0
PREAI
errChunlin Zhu; Yuming Lin; Yaojun Cai; You Li
errShare
errSave
Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation
err2024-05-02
err0
errOAAI
errDawei Gao; Haibin Wang; Yaliang Li; Xiuyu Sun; Yichen Qian; Bolin Ding; Jingren Zhou
errShare
errSave
CodeS: Towards Building Open-source Language Models for Text-to-SQL
err2024-05-30
err0
errOAAI
errHaoyang Li; Jing Zhang; Hanbing Liu; Ju Fan; Xiaokang Zhang; Jun Zhu; Renjie Wei; Hongyan Pan; Cuiping Li; Hong Chen
errShare
errSave
no more