Enhancing SQL learning with large language models: generating translations and explanations for educational use
Loading...
Author (Corporation)
Publication date
2025
Typ of student thesis
Course of study
Collections
Type
04B - Conference paper
Editors
Editor (Corporation)
Supervisor
Parent work
Proceedings of the Fourth International Conference on Innovations in Computing Research (ICR’25)
Special issue
DOI of the original publication
Series
Lecture Notes in Networks and Systems
Series number
1487
Volume
Issue / Number
Pages / Duration
273-282
Patent number
Publisher / Publishing institution
Springer
Place of publication / Event location
Cham
Edition
Version
Programming language
Assignee
Practice partner / Client
Abstract
We explore the potential of large language models (LLMs)
to help business users to understand SQL, with a view to include such techniques in teaching and programming support tools. We propose a new method which uses LLMs in two stages: content creation and content evaluation. Our method was tested with 32 SQL queries from Spider and five LLMs. We discovered that using RAG is not beneficial. Human evaluation showed that our method successfully generates quality outputs which can be used in teaching or business. Our students showed a preference for short structured explanations and found both the explanations and translations to be useful.
Keywords
Subject (DDC)
Event
Fourth International Conference on Innovations in Computing Research (ICR’25)
Exhibition start date
Exhibition end date
Conference start date
25.08.2025
Conference end date
27.08.2025
Date of the last check
ISBN
978-3-031-95651-5
978-3-031-95652-2
978-3-031-95652-2
ISSN
Language
English
Created during FHNW affiliation
Yes
Strategic action fields FHNW
Publication status
Published
Review
Peer review of the complete publication
Open access category
Closed
License
Citation
Moser, S. N., & Pustulka, E. (2025). Enhancing SQL learning with large language models: generating translations and explanations for educational use. In K. Daimi & A. Alsadoon (Eds.), Proceedings of the Fourth International Conference on Innovations in Computing Research (ICR’25) (pp. 273–282). Springer. https://doi.org/10.1007/978-3-031-95652-2_23