{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,1]],"date-time":"2025-10-01T15:57:45Z","timestamp":1759334265130,"version":"build-2065373602"},"reference-count":14,"publisher":"IEEE","license":[{"start":{"date-parts":[[2025,8,17]],"date-time":"2025-08-17T00:00:00Z","timestamp":1755388800000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2025,8,17]],"date-time":"2025-08-17T00:00:00Z","timestamp":1755388800000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"funder":[{"DOI":"10.13039\/100000001","name":"National Science Foundation","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100008569","name":"Oklahoma Center for the Advancement of Science and Technology","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100008569","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2025,8,17]]},"DOI":"10.1109\/case58245.2025.11163844","type":"proceedings-article","created":{"date-parts":[[2025,9,23]],"date-time":"2025-09-23T17:24:07Z","timestamp":1758648247000},"page":"3339-3344","source":"Crossref","is-referenced-by-count":0,"title":["Automated SQL Query Generation for an Intelligent Sewer Management System Using Large Language Models"],"prefix":"10.1109","author":[{"given":"Dharmendra Reddy","family":"Chitte","sequence":"first","affiliation":[{"name":"Oklahoma State University,Dharmendra Reddy Chitte is With the Computer Science Department,Stillwater,OK,USA,74078"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fei","family":"Liang","sequence":"additional","affiliation":[{"name":"School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Weihua","family":"Sheng","sequence":"additional","affiliation":[{"name":"School of Electrical and Computer Engineering, Oklahoma State University,Stillwater,OK,USA,74078"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yongwei","family":"Shan","sequence":"additional","affiliation":[{"name":"School of Civil and Environmental Engineering, Oklahoma State University,Stillwater,OK,USA,74078"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hossein","family":"Khaleghian","sequence":"additional","affiliation":[{"name":"InfraTie Solutions, LLC.,Stillwater,OK,USA,74074"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"article-title":"2021 report card for america\u2019s infrastructure","year":"2021","author":"of Civil Engineers","key":"ref1"},{"article-title":"Sanitary sewer overflows (ssos)","year":"2024","author":"Agency","key":"ref2"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.1109\/tkde.2025.3609486"},{"article-title":"Gpt-4 technical report","year":"2023","author":"Achiam","key":"ref4"},{"article-title":"Llama: Open and efficient foundation language models","year":"2023","author":"Touvron","key":"ref5"},{"article-title":"From natural language to sql: Review of llm-based text-to-sql systems","year":"2024","author":"Mohammadjafari","key":"ref6"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1145\/3737873"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.5220\/0012076900003538"},{"article-title":"Open-sql framework: Enhancing text-to-sql on open-source large language models","year":"2024","author":"Chen","key":"ref9"},{"key":"ref10","article-title":"Can llm already serve as a database interface? a big bench for large-scale database grounded text-to-sqls","volume":"36","author":"Li","year":"2024","journal-title":"Advances in Neural Information Processing Systems"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.5220\/0012555200003690"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.3390\/ijgi13010026"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.3390\/ijgi13100348"},{"article-title":"Sqlfuse: Enhancing text-to-sql performance through comprehensive llm synergy","year":"2024","author":"Zhang","key":"ref14"}],"event":{"name":"2025 IEEE 21st International Conference on Automation Science and Engineering (CASE)","start":{"date-parts":[[2025,8,17]]},"location":"Los Angeles, CA, USA","end":{"date-parts":[[2025,8,21]]}},"container-title":["2025 IEEE 21st International Conference on Automation Science and Engineering (CASE)"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx8\/11163731\/11163732\/11163844.pdf?arnumber=11163844","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,30]],"date-time":"2025-09-30T13:23:40Z","timestamp":1759238620000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/11163844\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8,17]]},"references-count":14,"URL":"https:\/\/doi.org\/10.1109\/case58245.2025.11163844","relation":{},"subject":[],"published":{"date-parts":[[2025,8,17]]}}}