{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,5]],"date-time":"2026-03-05T01:42:40Z","timestamp":1772674960432,"version":"3.50.1"},"reference-count":14,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2025,7,1]],"date-time":"2025-07-01T00:00:00Z","timestamp":1751328000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/deed.de"},{"start":{"date-parts":[[2025,10,17]],"date-time":"2025-10-17T00:00:00Z","timestamp":1760659200000},"content-version":"vor","delay-in-days":108,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/deed.de"}],"funder":[{"name":"Ostbayerische Technische Hochschule Regensburg"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Datenbank Spektrum"],"published-print":{"date-parts":[[2025,7]]},"abstract":"<jats:title>Abstract<\/jats:title>\n                  <jats:p>Large Language Models have advanced to a\u00a0resourceful tool with many applications. One particularly interesting use case is the LLM-aided generation of ad-hoc database queries and the possibility of subsequent processing of the results in a\u00a0way suiting the users intents. In this article, practical ways and experiences are described on how to effectively use LLMs to map a\u00a0natural-language user query to an SQL query conforming to a\u00a0specific database schema and post-processing the results of this query in order to, for example, create an appealing visualization. Best results are achieved under favorable circumstances, as, for example, a\u00a0clean and meaningful named database schema.<\/jats:p>","DOI":"10.1007\/s13222-025-00512-w","type":"journal-article","created":{"date-parts":[[2025,10,17]],"date-time":"2025-10-17T05:48:16Z","timestamp":1760680096000},"page":"95-101","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Experience Report: Hey LLM, Generate SQL!"],"prefix":"10.1007","volume":"25","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-5380-5692","authenticated-orcid":false,"given":"Florian","family":"Heinz","sequence":"first","affiliation":[]},{"given":"Johannes","family":"Schildgen","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2025,10,17]]},"reference":[{"key":"512_CR1","doi-asserted-by":"publisher","first-page":"149","DOI":"10.1145\/604045.604070","volume-title":"Proceedings of the 8th international conference on intelligent user interfaces, IUI 2003","author":"A Popescu","year":"2003","unstructured":"Popescu\u00a0A, Etzioni\u00a0O, Kautz\u00a0HA (2003) Towards a\u00a0theory of natural language interfaces to databases. In: Leake\u00a0DB, Johnson\u00a0WL, Andr\u00e9\u00a0E (eds) Proceedings of the 8th international conference on intelligent user interfaces, IUI 2003. Miami, FL, USA, pp\u00a0149\u2013157 https:\/\/doi.org\/10.1145\/604045.604070"},{"key":"512_CR2","doi-asserted-by":"publisher","first-page":"709","DOI":"10.1145\/2588555.2594519","volume-title":"Proceedings of the 2014 ACM SIGMOD international conference on management of data","author":"F Li","year":"2014","unstructured":"Li\u00a0F, Jagadish\u00a0HV (2014) Nalir: an interactive natural language interface for querying relational databases. In: Proceedings of the 2014 ACM SIGMOD international conference on management of data, pp\u00a0709\u2013712"},{"issue":"1","key":"512_CR3","doi-asserted-by":"publisher","first-page":"73","DOI":"10.14778\/2735461.2735468","volume":"8","author":"F Li","year":"2014","unstructured":"Li\u00a0F, Jagadish\u00a0HV (2014) Constructing an interactive natural language interface for relational databases. Proc Vldb Endow 8(1):73\u201384","journal-title":"Proc Vldb Endow"},{"key":"512_CR4","doi-asserted-by":"publisher","first-page":"821","DOI":"10.18420\/BTW2023-53","volume-title":"Datenbanksysteme F\u00fcr business, Technologie und web (BTW 2023), 20. Fachtagung des GI-Fachbereichs \u201eDatenbanken und Informationssysteme\u201c (DBIS)","author":"J Schildgen","year":"2023","unstructured":"Schildgen\u00a0J, Heinz\u00a0F, Olijnyk\u00a0A, Lindenau\u00a0A, Gesellschaft f\u00fcr Informatik e.V. (2023) Using SQL\/MED to query heterogeneous data sources with alexa voice commands. In: K\u00f6nig-Ries\u00a0B, Scherzinger\u00a0S, Lehner\u00a0W, Vossen\u00a0G (eds) Datenbanksysteme F\u00fcr business, Technologie und web (BTW 2023), 20. Fachtagung des GI-Fachbereichs \u201eDatenbanken und Informationssysteme\u201c (DBIS). Proceedings. LNI, Dresden, Germany, pp\u00a0821\u2013828 https:\/\/doi.org\/10.18420\/BTW2023-53"},{"key":"512_CR5","volume-title":"Seq2sql: generating structured queries from natural language using reinforcement learning. CoRR abs\/1709.00103","author":"V Zhong","year":"2017","unstructured":"Zhong\u00a0V, Xiong\u00a0C, Socher\u00a0R (2017) Seq2sql: generating structured queries from natural language using reinforcement learning. CoRR abs\/1709.00103"},{"key":"512_CR6","volume-title":"Sqlnet: generating structured queries from natural language without reinforcement learning. CoRR abs\/1711.04436","author":"X Xu","year":"2017","unstructured":"Xu\u00a0X, Liu\u00a0C, Song\u00a0D (2017) Sqlnet: generating structured queries from natural language without reinforcement learning. CoRR abs\/1711.04436"},{"key":"512_CR7","first-page":"3794","volume-title":"Proceedings of the 31st international conference on computational linguistics, COLING 2025","author":"J Shi","year":"2025","unstructured":"Shi\u00a0J, Xu\u00a0B, Liang\u00a0J, Xiao\u00a0Y, Chen\u00a0J, Xie\u00a0C, Wang\u00a0P, Wang\u00a0W (2025) Gen-sql: efficient text-to-sql by bridging natural language question and database schema with pseudo-schema. In: Rambow\u00a0O, Wanner\u00a0L, Apidianaki\u00a0M, Al-Khalifa\u00a0H, Eugenio\u00a0BD, Schockaert\u00a0S (eds) Proceedings of the 31st international conference on computational linguistics, COLING 2025. Association for Computational Linguistics, Abu Dhabi, UAE, pp\u00a03794\u20133807 (https:\/\/aclanthology.org\/2025.coling-main.256\/)"},{"key":"512_CR8","doi-asserted-by":"publisher","unstructured":"Chen K, Chen Y, Yu X, Koudas N (2025) Reliable text-to-sql with adaptive abstention. CoRR abs\/2501.10858. https:\/\/doi.org\/10.48550\/ARXIV.2501.108582501.10858","DOI":"10.48550\/ARXIV.2501.108582501.10858"},{"key":"512_CR9","doi-asserted-by":"publisher","unstructured":"Nascimento E, Avila CVS, Izquierdo YT, Garc\u00eda GM, Andrade LFL, Facina MSP, Lemos M, Casanova MA (2025) Text-to-sql based on large language models and database keyword search. CoRR abs\/2501.13594. https:\/\/doi.org\/10.48550\/ARXIV.2501.135942501.13594","DOI":"10.48550\/ARXIV.2501.135942501.13594"},{"key":"512_CR10","doi-asserted-by":"publisher","first-page":"16388","DOI":"10.18653\/v1\/2024.findings-acl.971","volume-title":"Findings of the association for computational linguistics: aCL 2024","author":"J Ryu","year":"2024","unstructured":"Ryu\u00a0J, Cho\u00a0S, Lee\u00a0G, Choi\u00a0E (2024) EHR-seqSQL : a\u00a0sequential text-to-SQL dataset for interactively exploring electronic health records. In: Ku\u00a0L\u2011W, Martins\u00a0A, Srikumar\u00a0V (eds) Findings of the association for computational linguistics: aCL 2024. Association for Computational Linguistics, Bangkok, Thailand, pp\u00a016388\u201316407 https:\/\/doi.org\/10.18653\/v1\/2024.findings-acl.971 (https:\/\/aclanthology.org\/2024.findings-acl.971\/)"},{"key":"512_CR11","series-title":"Proceedings, Part I. Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"93","DOI":"10.1007\/978-3-031-68309-1_8","volume-title":"Database and expert systems applications\u201435th international conference, DEXA 2024","author":"GMC Coelho","year":"2024","unstructured":"Coelho\u00a0GMC, Nascimento\u00a0E, Izquierdo\u00a0YT, Garc\u00eda\u00a0GM, Feij\u00f3\u00a0L, Lemos\u00a0M, Garcia\u00a0RLS, Oliveira\u00a0AR, Pinheiro\u00a0J, Casanova\u00a0MA (2024) Improving the accuracy of text-to-sql tools based on large language models for real-world relational databases. In: Strauss\u00a0C, Amagasa\u00a0T, Manco\u00a0G, Kotsis\u00a0G, Tjoa\u00a0AM, Khalil\u00a0I (eds) Database and expert systems applications\u201435th international conference, DEXA 2024. Proceedings, Part I. Lecture Notes in Computer Science, vol 14910. Springer, Naples, Italy, pp\u00a093\u2013107 https:\/\/doi.org\/10.1007\/978-3-031-68309-1_8"},{"key":"512_CR12","doi-asserted-by":"publisher","unstructured":"Hong Z, Yuan Z, Zhang Q, Chen H, Dong J, Huang F, Huang X (2024) Next-generation database interfaces: a\u00a0survey of LLM-based text-to-SQL. CoRR abs\/2406.08426. https:\/\/doi.org\/10.48550\/ARXIV.2406.084262406.08426","DOI":"10.48550\/ARXIV.2406.084262406.08426"},{"key":"512_CR13","doi-asserted-by":"publisher","first-page":"30497","DOI":"10.1109\/ACCESS.2025.3540072","volume":"13","author":"ZEH Zhan","year":"2025","unstructured":"Zhan\u00a0ZEH, Song\u00a0M (2025) Leveraging large language model for enhanced text-to-SQL parsing. IEEE Access 13:30497\u201330504. https:\/\/doi.org\/10.1109\/ACCESS.2025.3540072","journal-title":"IEEE Access"},{"key":"512_CR14","doi-asserted-by":"publisher","first-page":"819","DOI":"10.18420\/BTW2025-47","volume-title":"Datenbanksysteme f\u00fcr business, Technologie und web (BTW 2025), 21. fachtagung des GI-Fachbereichs \u201edatenbanken und Informationssysteme\u201c (DBIS)","author":"J Schildgen","year":"2025","unstructured":"Schildgen\u00a0J, Heinz\u00a0F (2025) A\u00a0showcase of LLms in action: SQL generation from natural language (demo paper). In: Klettke\u00a0M, Schenkel\u00a0R, Henrich\u00a0A, Nicklas\u00a0D, Sch\u00fcle\u00a0ME, Meyer-Wegener\u00a0K (eds) Datenbanksysteme f\u00fcr business, Technologie und web (BTW 2025), 21. fachtagung des GI-Fachbereichs \u201edatenbanken und Informationssysteme\u201c (DBIS). Proceedings. LNI, Bamberg, Germany, pp\u00a0819\u2013825 https:\/\/doi.org\/10.18420\/BTW2025-47"}],"container-title":["Datenbank-Spektrum"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-025-00512-w.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s13222-025-00512-w\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-025-00512-w.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,24]],"date-time":"2025-10-24T17:14:55Z","timestamp":1761326095000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s13222-025-00512-w"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,7]]},"references-count":14,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2025,7]]}},"alternative-id":["512"],"URL":"https:\/\/doi.org\/10.1007\/s13222-025-00512-w","relation":{},"ISSN":["1618-2162","1610-1995"],"issn-type":[{"value":"1618-2162","type":"print"},{"value":"1610-1995","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,7]]},"assertion":[{"value":"31 March 2025","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"4 September 2025","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"17 October 2025","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}