{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,4]],"date-time":"2026-02-04T18:11:18Z","timestamp":1770228678381,"version":"3.49.0"},"publisher-location":"New York, NY, USA","reference-count":34,"publisher":"ACM","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2025,6,22]]},"DOI":"10.1145\/3735091.3737534","type":"proceedings-article","created":{"date-parts":[[2025,7,29]],"date-time":"2025-07-29T06:24:11Z","timestamp":1753770251000},"page":"29-34","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["CodeLens: A Generative AI Framework for Automated Feedback on SQL Assignments"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0002-4113-6441","authenticated-orcid":false,"given":"Abdulrahman","family":"Alrabah","sequence":"first","affiliation":[{"name":"University of Illinois Urbana-Champaign, Urbana, IL, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1106-7190","authenticated-orcid":false,"given":"Abdussalam","family":"Alawini","sequence":"additional","affiliation":[{"name":"University of Illinois Urbana-Champaign, Urbana, IL, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2025,7,28]]},"reference":[{"key":"e_1_3_3_1_2_2","doi-asserted-by":"publisher","DOI":"10.1145\/2899415.2899464"},{"key":"e_1_3_3_1_3_2","doi-asserted-by":"publisher","DOI":"10.1145\/2839509.2844640"},{"key":"e_1_3_3_1_4_2","doi-asserted-by":"publisher","DOI":"10.1145\/2729094.2742620"},{"key":"e_1_3_3_1_5_2","doi-asserted-by":"publisher","DOI":"10.1145\/3596673.3596976"},{"key":"e_1_3_3_1_6_2","first-page":"482","volume-title":"International Conference on Information Technology: Coding and Computing (ITCC\u201905)-Volume II","volume":"1","author":"Barker Steve","year":"2005","unstructured":"Steve Barker and Paul Douglas. 2005. An intelligent tutoring system for program semantics. In International Conference on Information Technology: Coding and Computing (ITCC\u201905)-Volume II , Vol.\u00a01. IEEE, 482\u2013487."},{"key":"e_1_3_3_1_7_2","doi-asserted-by":"crossref","first-page":"197","DOI":"10.1007\/978-3-319-47717-6_17","volume-title":"Advances in Conceptual Modeling: ER 2016 Workshops, AHA, MoBiD, MORE-BI, MReBA, QMMQ, SCME, and WM2SP, Gifu, Japan, November 14\u201317, 2016, Proceedings 35","author":"Bider Ilia","year":"2016","unstructured":"Ilia Bider and David Rogers. 2016. YASQLT\u2013Yet Another SQL Tutor: A Pragmatic Approach. In Advances in Conceptual Modeling: ER 2016 Workshops, AHA, MoBiD, MORE-BI, MReBA, QMMQ, SCME, and WM2SP, Gifu, Japan, November 14\u201317, 2016, Proceedings 35. Springer, 197\u2013206."},{"key":"e_1_3_3_1_8_2","doi-asserted-by":"publisher","unstructured":"Stefan Brass and Christian Goldberg. 2006. Semantic errors in SQL queries: A quite complete list. Journal of Systems and Software 79 5 (2006) 630\u2013644. 10.1016\/j.jss.2005.06.028Quality Software.","DOI":"10.1016\/j.jss.2005.06.028"},{"key":"e_1_3_3_1_9_2","unstructured":"Ashley DiFranza. 2020. 5 Reasons SQL is the Need-to-Know Skill for Data Analysts. (2020)."},{"key":"e_1_3_3_1_10_2","first-page":"1","volume-title":"Fourth International Conference on the Applications of Digital Information and Web Technologies (ICADIWT 2011)","author":"Dollinger Robert","year":"2011","unstructured":"Robert Dollinger and Kent Thomas. 2011. Using LINQ transformation patterns to evaluate SQL queries. In Fourth International Conference on the Applications of Digital Information and Web Technologies (ICADIWT 2011). IEEE, 1\u20136."},{"key":"e_1_3_3_1_11_2","doi-asserted-by":"publisher","DOI":"10.1145\/3626252.3630817"},{"key":"e_1_3_3_1_12_2","doi-asserted-by":"publisher","unstructured":"Siqi Han Yu Wang and Xuesong Lu. 2023. ErrorCLR: Semantic Error Classification Localization and Repair for Introductory Programming Assignments. 10.1145\/3539618.3591680","DOI":"10.1145\/3539618.3591680"},{"key":"e_1_3_3_1_13_2","unstructured":"HANLijun. 2018. SQL: A Supposed English-like Language. https:\/\/www.datasciencecentral.com\/sql-a-supposed-english-like-language\/"},{"key":"e_1_3_3_1_14_2","doi-asserted-by":"crossref","unstructured":"Sven Jacobs and Steffen Jaschke. 2024. Evaluating the Application of Large Language Models to Generate Feedback in Programming Education. arXiv preprint arXiv:https:\/\/arXiv.org\/abs\/2403.09744 (2024).","DOI":"10.1109\/EDUCON60312.2024.10578838"},{"key":"e_1_3_3_1_15_2","doi-asserted-by":"crossref","first-page":"212","DOI":"10.1109\/ICALT55010.2022.00069","volume-title":"2022 International Conference on Advanced Learning Technologies (ICALT)","author":"Karimzadeh Mohammad","year":"2022","unstructured":"Mohammad Karimzadeh and Hasan\u00a0M Jamil. 2022. ViSQL: An Intelligent Online SQL Tutoring System. In 2022 International Conference on Advanced Learning Technologies (ICALT). IEEE, 212\u2013213."},{"key":"e_1_3_3_1_16_2","doi-asserted-by":"publisher","unstructured":"R. Kearns Stephen Shead and A. Fekete. 1997. A teaching system for SQL. ACSE \u201997 (1997). 10.1145\/299359.299391","DOI":"10.1145\/299359.299391"},{"key":"e_1_3_3_1_17_2","doi-asserted-by":"publisher","DOI":"10.1145\/3545945.3569770"},{"key":"e_1_3_3_1_18_2","doi-asserted-by":"publisher","DOI":"10.1109\/FIE58773.2023.10343409"},{"key":"e_1_3_3_1_19_2","doi-asserted-by":"publisher","DOI":"10.1145\/3524610.3529158"},{"key":"e_1_3_3_1_20_2","doi-asserted-by":"publisher","DOI":"10.1145\/273133.274318"},{"key":"e_1_3_3_1_21_2","unstructured":"OpenAI. 2023. GPT-3.5-turbo-1106. https:\/\/openai.com\/. Accessed: 2024-01-20."},{"key":"e_1_3_3_1_22_2","doi-asserted-by":"publisher","DOI":"10.1145\/3341525.3387391"},{"key":"e_1_3_3_1_23_2","doi-asserted-by":"crossref","first-page":"1251","DOI":"10.1145\/3626252.3630851","volume-title":"Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 1","author":"Oliveira Gabriel Silva\u00a0de","year":"2024","unstructured":"Gabriel Silva\u00a0de Oliveira, Zhikai Gao, Sarah Heckman, and Collin Lynch. 2024. Exploring Novice Programmers\u2019 Testing Behavior: A First Step to Define Coding Struggle. In Proceedings of the 55th ACM Technical Symposium on Computer Science Education V. 1. 1251\u20131257."},{"key":"e_1_3_3_1_24_2","doi-asserted-by":"publisher","DOI":"10.1109\/FIE44824.2020.9274114"},{"key":"e_1_3_3_1_25_2","doi-asserted-by":"publisher","DOI":"10.1145\/3287324.3287359"},{"key":"e_1_3_3_1_26_2","doi-asserted-by":"crossref","unstructured":"Toni Taipalus Mikko Siponen and Tero Vartiainen. 2018. Errors and complications in SQL query formulation. ACM Transactions on Computing Education (TOCE) 18 3 (2018) 1\u201329.","DOI":"10.1145\/3231712"},{"key":"e_1_3_3_1_27_2","volume-title":"Proceedings of the 55 th ACM Technical Symp. on Computer Science Education","volume":"1","author":"Taylor Andrew","year":"2023","unstructured":"Andrew Taylor, Alexandra Vassar, Jake Renzella, and Hammond Pearce. 2023. Dcc-help: Generating context-aware compiler error explanations with large language models. In Proceedings of the 55 th ACM Technical Symp. on Computer Science Education , Vol.\u00a01."},{"key":"e_1_3_3_1_28_2","doi-asserted-by":"publisher","DOI":"10.1145\/3626252.3630822"},{"key":"e_1_3_3_1_29_2","first-page":"525","volume-title":"ICTERI","author":"Vagin Ievgen","year":"2019","unstructured":"Ievgen Vagin, Olena Havrylenko, Juan Pablo\u00a0Mart\u00ednez Bastida, and Andrey Chukhray. 2019. Computer Intelligent Tutoring System\" SQLTOR\".. In ICTERI. 525\u2013530."},{"key":"e_1_3_3_1_30_2","unstructured":"Jesus Vigo. 2020. 5 Programming Languages Database Administrators Should Learn."},{"key":"e_1_3_3_1_31_2","doi-asserted-by":"publisher","DOI":"10.1145\/3626252.3630764"},{"key":"e_1_3_3_1_32_2","doi-asserted-by":"publisher","DOI":"10.1145\/3531072.3535319"},{"key":"e_1_3_3_1_33_2","doi-asserted-by":"publisher","DOI":"10.1145\/3596673.3596973"},{"key":"e_1_3_3_1_34_2","doi-asserted-by":"publisher","DOI":"10.1109\/FIE58773.2023.10343207"},{"key":"e_1_3_3_1_35_2","doi-asserted-by":"publisher","DOI":"10.1145\/3430895.3460979"}],"event":{"name":"SIGMOD\/PODS '25: International Conference on Management of Data","location":"Berlin Germany","acronym":"DataEd '25","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 4th International Workshop on Data Systems Education: Bridging Education Practice with Education Research"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3735091.3737534","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,29]],"date-time":"2025-07-29T06:24:16Z","timestamp":1753770256000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3735091.3737534"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,6,22]]},"references-count":34,"alternative-id":["10.1145\/3735091.3737534","10.1145\/3735091"],"URL":"https:\/\/doi.org\/10.1145\/3735091.3737534","relation":{},"subject":[],"published":{"date-parts":[[2025,6,22]]},"assertion":[{"value":"2025-07-28","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}