Text-to-SQL: A methodical review of challenges and models
Turkish Journal of Electrical Engineering and Computer Sciences · 20.05.2024 · 32 (3) · 403-419
DOI: 10.55730/1300-0632.4077 ↗Kurz gefasst
Fachartikel in der Zeitschrift Turkish Journal of Electrical Engineering and Computer Sciences, online erschienen am 20.05.2024. Verfasst von Ali Buğra KANBUROĞLU und 1 weiteren Autor:innen. Die Arbeit wurde bisher 33-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
This survey focuses on Text-to-SQL, automated translation of natural language queries into SQL queries. Initially, we describe the problem and its main challenges. Then, by following the PRISMA systematic review methodology, we survey the existing Text-to-SQL review papers in the literature. We apply the same method to extract proposed Text-to-SQL models and classify them with respect to used evaluation metrics and benchmarks. We highlight the accuracies achieved by various models on Text-to-SQL datasets and discuss execution-guided evaluation strategies. We present insights into model training times and implementations of different models. We also explore the availability of Text-to-SQL datasets in non-English languages. Additionally, we focus on large language model (LLM) based approaches for the Text-to-SQL task, where we examine LLM-based studies in the literature and subsequently evaluate the LLMs on the cross-domain Spider dataset. Finally, we conclude with a discussion of future directions for Text-to-SQL research, identifying potential areas of improvement and advancements in this field.
Zitieren
APA
KANBUROĞLU, A. B., & TEK, F. B. (2024). Text-to-SQL: A methodical review of challenges and models. Turkish Journal of Electrical Engineering and Computer Sciences, 32(3), 403-419. https://doi.org/10.55730/1300-0632.4077
Vancouver
KANBUROĞLU AB, TEK FB. Text-to-SQL: A methodical review of challenges and models. Turkish Journal of Electrical Engineering and Computer Sciences. 2024;32(3):403-419. doi:10.55730/1300-0632.4077
BibTeX
@article{KANBUROLU2024,
author = {KANBUROĞLU, Ali Buğra and TEK, Faik Boray},
title = {Text-to-SQL: A methodical review of challenges and models},
journal = {Turkish Journal of Electrical Engineering and Computer Sciences},
year = {2024},
volume = {32},
number = {3},
pages = {403--419},
doi = {10.55730/1300-0632.4077}
}
EUVIMED