@article{ART003329500},
author={Myoungkuk Nam and Namgyu Kim},
title={Improving Text-to-SQL Reliability by Leveraging Operational SQL},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2026},
volume={31},
number={4},
pages={147-156}
TY - JOUR
AU - Myoungkuk Nam
AU - Namgyu Kim
TI - Improving Text-to-SQL Reliability by Leveraging Operational SQL
JO - Journal of The Korea Society of Computer and Information
PY - 2026
VL - 31
IS - 4
PB - The Korean Society Of Computer And Information
SP - 147
EP - 156
SN - 1598-849X
AB - Effective use of relational databases requires substantial SQL expertise, driving active research into Text-to-SQL, which aims to translate natural language queries into SQL statements. Recently, generation-based approaches leveraging large language models (LLMs) have gained considerable attention. However, purely LLM-based methods face inherent limitations in handling natural language ambiguity, schema linking, and the reliability of generated outputs. Against this backdrop, this study proposes OpSQL-Leverage (OSL), a methodology that exploits SQL queries accumulated in real-world operational environments as core knowledge assets. Specifically, OSL selects candidate SQLs from an operational database based on an LLM-generated SQL, then synthesizes these candidates with the original natural language query to produce the final SQL. Experiments on the SPIDER dataset show that OSL achieves higher accuracy than purely LLM-based Text-to-SQL models. This work is significant in that it extends retrieval-augmented generation (RAG) approaches to the Text-to-SQL domain by leveraging structured SQL assets within operational databases as external knowledge.
KW - Large Language Model;Text-to-SQL;DBMS;SPIDER dataset
DO -
UR -
ER -
Myoungkuk Nam and Namgyu Kim. (2026). Improving Text-to-SQL Reliability by Leveraging Operational SQL. Journal of The Korea Society of Computer and Information, 31(4), 147-156.
Myoungkuk Nam and Namgyu Kim. 2026, "Improving Text-to-SQL Reliability by Leveraging Operational SQL", Journal of The Korea Society of Computer and Information, vol.31, no.4 pp.147-156.
Myoungkuk Nam, Namgyu Kim "Improving Text-to-SQL Reliability by Leveraging Operational SQL" Journal of The Korea Society of Computer and Information 31.4 pp.147-156 (2026) : 147.
Myoungkuk Nam, Namgyu Kim. Improving Text-to-SQL Reliability by Leveraging Operational SQL. 2026; 31(4), 147-156.
Myoungkuk Nam and Namgyu Kim. "Improving Text-to-SQL Reliability by Leveraging Operational SQL" Journal of The Korea Society of Computer and Information 31, no.4 (2026) : 147-156.
Myoungkuk Nam; Namgyu Kim. Improving Text-to-SQL Reliability by Leveraging Operational SQL. Journal of The Korea Society of Computer and Information, 31(4), 147-156.
Myoungkuk Nam; Namgyu Kim. Improving Text-to-SQL Reliability by Leveraging Operational SQL. Journal of The Korea Society of Computer and Information. 2026; 31(4) 147-156.
Myoungkuk Nam, Namgyu Kim. Improving Text-to-SQL Reliability by Leveraging Operational SQL. 2026; 31(4), 147-156.
Myoungkuk Nam and Namgyu Kim. "Improving Text-to-SQL Reliability by Leveraging Operational SQL" Journal of The Korea Society of Computer and Information 31, no.4 (2026) : 147-156.
