{"id":"https://openalex.org/W6963224096","doi":"https://doi.org/10.18420/btw2025-47","title":"A Showcase of LLMs in Action: SQL Generation from Natural Language (Demo Paper)","display_name":"A Showcase of LLMs in Action: SQL Generation from Natural Language (Demo Paper)","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W6963224096","doi":"https://doi.org/10.18420/btw2025-47"},"language":"en","primary_location":{"id":"doi:10.18420/btw2025-47","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-47","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.18420/btw2025-47","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Schildgen, Johannes","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Schildgen, Johannes","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Heinz, Florian","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Heinz, Florian","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.1318,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.93545403,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.25459998846054077,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.25459998846054077,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T12128","display_name":"AI in Service Interactions","score":0.22169999778270721,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10028","display_name":"Topic Modeling","score":0.0737999975681305,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.7555000185966492},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6018999814987183},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.5321999788284302},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5288000106811523},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4666999876499176},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.448199987411499},{"id":"https://openalex.org/keywords/data-control-language","display_name":"Data control language","score":0.43299999833106995},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.42809998989105225},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4278999865055084}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8349999785423279},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7555000185966492},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6018999814987183},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5321999788284302},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5288000106811523},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4999000132083893},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4666999876499176},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.448199987411499},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.43299999833106995},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.42809998989105225},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4278999865055084},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.4277999997138977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4268999993801117},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3513999879360199},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.3368000090122223},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.328900009393692},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.322299987077713},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.3165000081062317},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.31619998812675476},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.31380000710487366},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.3125},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.31209999322891235},{"id":"https://openalex.org/C2777801307","wikidata":"https://www.wikidata.org/wiki/Q2088390","display_name":"Spelling","level":2,"score":0.3102000057697296},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.30799999833106995},{"id":"https://openalex.org/C4924752","wikidata":"https://www.wikidata.org/wiki/Q184148","display_name":"Plug-in","level":2,"score":0.3050000071525574},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.304500013589859},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2766000032424927},{"id":"https://openalex.org/C46681722","wikidata":"https://www.wikidata.org/wiki/Q4725589","display_name":"Alias","level":2,"score":0.2700999975204468},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.26969999074935913},{"id":"https://openalex.org/C190812933","wikidata":"https://www.wikidata.org/wiki/Q28923","display_name":"Chart","level":2,"score":0.2599000036716461}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18420/btw2025-47","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-47","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.18420/btw2025-47","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2025-47","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[{"score":0.7388342022895813,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Today,":[0],"large":[1,28],"language":[2],"models":[3],"are":[4,33,61],"a":[5,27,48,52,132,141],"very":[6],"efficient":[7],"tool":[8],"for":[9,38,82,123,125],"human-computer":[10],"interaction":[11],"using":[12],"natural":[13,129],"language.":[14],"Chatbots":[15],"like":[16],"ChatGPT":[17],"and":[18,91,139],"their":[19],"corresponding":[20],"APIs":[21],"can":[22,69,94],"be":[23,95],"used":[24],"to":[25,71],"solve":[26],"variety":[29],"of":[30,59,89],"tasks":[31],"that":[32],"provided":[34,64,101],"in":[35,47,102,112,116,128],"human-comprehensible":[36],"sentences,":[37],"example":[39],"generating":[40],"SQL":[41,45,60,145],"queries.":[42],"Executing":[43],"spoken":[44],"queries":[46],"database":[49,99,118],"system":[50],"poses":[51],"challenge,":[53],"because":[54],"the":[55,67,73,78,86,98,103],"various":[56],"syntactical":[57],"details":[58],"usually":[62],"not":[63],"verbally.":[65],"Here,":[66],"LLM":[68,104],"help":[70],"augment":[72],"recognized":[74],"raw":[75],"query":[76],"with":[77],"syntax":[79],"elements":[80],"needed":[81],"successful":[83],"execution.":[84],"Furthermore,":[85],"correct":[87],"spelling":[88],"table":[90],"column":[92],"names":[93],"derived":[96],"from":[97],"schema":[100],"prompt.":[105],"This":[106],"work":[107],"showcases":[108],"four":[109],"use":[110],"cases":[111],"which":[113],"LLMs":[114],"assist":[115],"querying":[117],"systems:":[119],"(1)":[120],"A":[121],"plugin":[122],"phpMyAdmin":[124],"voice-query":[126],"input":[127],"language,":[130],"(2)":[131],"chart":[133],"generator,":[134],"(3)":[135],"an":[136],"Alexa":[137],"skill,":[138],"(4)":[140],"speech-controlled":[142],"action":[143],"game":[144],"Invaders.":[146]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}