{"id":"https://openalex.org/W4415966023","doi":"https://doi.org/10.1145/3769994.3770024","title":"Trends in Students' SQL Queries in the Era of Generative AI","display_name":"Trends in Students' SQL Queries in the Era of Generative AI","publication_year":2025,"publication_date":"2025-11-06","ids":{"openalex":"https://openalex.org/W4415966023","doi":"https://doi.org/10.1145/3769994.3770024"},"language":null,"primary_location":{"id":"doi:10.1145/3769994.3770024","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769994.3770024","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3769994.3770024","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004899512","display_name":"Antti Laaksonen","orcid":"https://orcid.org/0000-0002-5369-5518"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":true,"raw_author_name":"Antti Laaksonen","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0000-0002-5369-5518","affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089260178","display_name":"Kai Korpimies","orcid":"https://orcid.org/0009-0007-0889-0799"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Kai Korpimies","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0009-0007-0889-0799","affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063812015","display_name":"Matti Luukkainen","orcid":"https://orcid.org/0000-0003-4779-4998"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Matti Luukkainen","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0000-0003-4779-4998","affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5004899512"],"corresponding_institution_ids":["https://openalex.org/I133731052"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.31082399,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.16689999401569366,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.16689999401569366,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.14790000021457672,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.06800000369548798,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8501999974250793},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5968000292778015},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.46399998664855957},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.43869999051094055},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.421999990940094},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.4043000042438507},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.3912999927997589},{"id":"https://openalex.org/keywords/generative-grammar","display_name":"Generative grammar","score":0.3711000084877014}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8501999974250793},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.847599983215332},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5968000292778015},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.46399998664855957},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.43869999051094055},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42980000376701355},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.421999990940094},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4092000126838684},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4043000042438507},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.3912999927997589},{"id":"https://openalex.org/C39890363","wikidata":"https://www.wikidata.org/wiki/Q36108","display_name":"Generative grammar","level":2,"score":0.3711000084877014},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.35580000281333923},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.33500000834465027},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.2946000099182129},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.29190000891685486},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.29159998893737793},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.28519999980926514},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.2851000130176544},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.2816999852657318},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.28130000829696655},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.2759000062942505},{"id":"https://openalex.org/C167966045","wikidata":"https://www.wikidata.org/wiki/Q5532625","display_name":"Generative model","level":3,"score":0.2687999904155731},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2542000114917755}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3769994.3770024","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769994.3770024","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3769994.3770024","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769994.3770024","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th Koli Calling International Conference on Computing Education Research","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W4361019453","https://openalex.org/W4388212294","https://openalex.org/W4392542342","https://openalex.org/W4393157398","https://openalex.org/W4396681029","https://openalex.org/W4398186469","https://openalex.org/W4399062448","https://openalex.org/W4400224603","https://openalex.org/W4400224630","https://openalex.org/W4400811346","https://openalex.org/W4402042542","https://openalex.org/W4402671641","https://openalex.org/W4403182022","https://openalex.org/W4403536967","https://openalex.org/W4404051654"],"related_works":[],"abstract_inverted_index":{"This":[0],"paper":[1],"studies":[2],"recent":[3],"trends":[4],"in":[5,8,63,69,93],"SQL":[6,19,24,88,109,122],"queries":[7,25,46,64,89,110,123],"an":[9],"introductory":[10],"databases":[11],"course.":[12],"The":[13],"course":[14,51],"includes":[15],"a":[16,34],"set":[17],"of":[18,43],"exercises":[20],"where":[21],"students":[22,47,101],"create":[23,87,108],"that":[26,60,81],"retrieve":[27],"information":[28],"from":[29,37],"database":[30],"tables.":[31],"We":[32],"analyze":[33],"dataset":[35],"collected":[36],"the":[38,50,54,82,120],"years":[39],"2020\u20132024,":[40],"which":[41],"consists":[42],"almost":[44],"340,000":[45],"submitted":[48],"to":[49,107],"system.":[52],"From":[53],"data,":[55],"it":[56],"can":[57,90,98],"be":[58,91],"seen":[59,92],"certain":[61],"patterns":[62],"are":[65,124],"clearly":[66],"more":[67],"prevalent":[68],"2023":[70],"and":[71,111],"2024":[72],"than":[73],"before.":[74],"A":[75],"possible":[76],"reason":[77],"for":[78],"this":[79],"is":[80],"way":[83,121],"generative":[84],"AI":[85,105],"tools":[86,106,117],"students\u2019":[94],"submissions.":[95],"Our":[96],"results":[97],"help":[99],"identify":[100],"who":[102],"have":[103],"used":[104],"provide":[112],"insight":[113],"into":[114],"how":[115],"these":[116],"might":[118],"influence":[119],"written.":[125]},"counts_by_year":[],"updated_date":"2025-11-07T23:20:04.922697","created_date":"2025-11-06T00:00:00"}