{"id":"https://openalex.org/W4415697133","doi":"https://doi.org/10.1145/3764915.3770724","title":"From Queries to Insights: Agentic LLM Pipelines for Spatio-Temporal Text-to-SQL","display_name":"From Queries to Insights: Agentic LLM Pipelines for Spatio-Temporal Text-to-SQL","publication_year":2025,"publication_date":"2025-10-30","ids":{"openalex":"https://openalex.org/W4415697133","doi":"https://doi.org/10.1145/3764915.3770724"},"language":null,"primary_location":{"id":"doi:10.1145/3764915.3770724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764915.3770724","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 1st ACM SIGSPATIAL International Workshop on Generative and Agentic AI for Multi-Modality Space-Time Intelligence","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3764915.3770724","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5120188676","display_name":"Manu Redd","orcid":null},"institutions":[{"id":"https://openalex.org/I146416000","display_name":"University of Kansas","ror":"https://ror.org/001tmjg57","country_code":"US","type":"education","lineage":["https://openalex.org/I146416000"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Manu Redd","raw_affiliation_strings":["University of Kansas, Lawrence, USA"],"raw_orcid":"https://orcid.org/0009-0001-2255-1618","affiliations":[{"raw_affiliation_string":"University of Kansas, Lawrence, USA","institution_ids":["https://openalex.org/I146416000"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008836594","display_name":"Tao Zhe","orcid":"https://orcid.org/0000-0003-4942-9775"},"institutions":[{"id":"https://openalex.org/I146416000","display_name":"University of Kansas","ror":"https://ror.org/001tmjg57","country_code":"US","type":"education","lineage":["https://openalex.org/I146416000"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tao Zhe","raw_affiliation_strings":["University of Kansas, Lawrence, USA"],"raw_orcid":"https://orcid.org/0000-0003-4942-9775","affiliations":[{"raw_affiliation_string":"University of Kansas, Lawrence, USA","institution_ids":["https://openalex.org/I146416000"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101737969","display_name":"Dongjie Wang","orcid":"https://orcid.org/0000-0003-3948-0059"},"institutions":[{"id":"https://openalex.org/I146416000","display_name":"University of Kansas","ror":"https://ror.org/001tmjg57","country_code":"US","type":"education","lineage":["https://openalex.org/I146416000"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dongjie Wang","raw_affiliation_strings":["University of Kansas, Lawrence, USA"],"raw_orcid":"https://orcid.org/0000-0003-3948-0059","affiliations":[{"raw_affiliation_string":"University of Kansas, Lawrence, USA","institution_ids":["https://openalex.org/I146416000"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I146416000"],"apc_list":null,"apc_paid":null,"fwci":1.6559,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.85289324,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"6","last_page":"14"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.24699999392032623,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.24699999392032623,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.15710000693798065,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.07940000295639038,"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/schema","display_name":"Schema (genetic algorithms)","score":0.5871999859809875},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5386999845504761},{"id":"https://openalex.org/keywords/orchestration","display_name":"Orchestration","score":0.4763000011444092},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.460099995136261},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4097999930381775},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.40549999475479126},{"id":"https://openalex.org/keywords/baseline","display_name":"Baseline (sea)","score":0.40470001101493835},{"id":"https://openalex.org/keywords/data-exploration","display_name":"Data exploration","score":0.39879998564720154}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7971000075340271},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5871999859809875},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5386999845504761},{"id":"https://openalex.org/C199168358","wikidata":"https://www.wikidata.org/wiki/Q3367000","display_name":"Orchestration","level":3,"score":0.4763000011444092},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.460099995136261},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.41260001063346863},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4097999930381775},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.40549999475479126},{"id":"https://openalex.org/C12725497","wikidata":"https://www.wikidata.org/wiki/Q810247","display_name":"Baseline (sea)","level":2,"score":0.40470001101493835},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.39879998564720154},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3619000017642975},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.3310999870300293},{"id":"https://openalex.org/C175309249","wikidata":"https://www.wikidata.org/wiki/Q725864","display_name":"Pipeline transport","level":2,"score":0.3303000032901764},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.32199999690055847},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.31450000405311584},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.31299999356269836},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.30970001220703125},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.30559998750686646},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.2939999997615814},{"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/C185578843","wikidata":"https://www.wikidata.org/wiki/Q10609775","display_name":"Information visualization","level":3,"score":0.2831000089645386},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.2759000062942505},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.26669999957084656},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.2662000060081482},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.26249998807907104},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2533999979496002},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.25130000710487366}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3764915.3770724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764915.3770724","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 1st ACM SIGSPATIAL International Workshop on Generative and Agentic AI for Multi-Modality Space-Time Intelligence","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2510.25997","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2510.25997","pdf_url":"https://arxiv.org/pdf/2510.25997","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3764915.3770724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764915.3770724","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 1st ACM SIGSPATIAL International Workshop on Generative and Agentic AI for Multi-Modality Space-Time Intelligence","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2071702404","https://openalex.org/W2890431379"],"related_works":[],"abstract_inverted_index":{"Natural-language-to-SQL":[0],"(NL-to-SQL)":[1],"systems":[2,21],"hold":[3],"promise":[4],"for":[5],"democratizing":[6],"access":[7],"to":[8,13],"structured":[9],"data,":[10],"allowing":[11],"users":[12],"query":[14],"databases":[15],"without":[16],"learning":[17],"SQL.":[18],"Yet":[19],"existing":[20],"struggle":[22],"with":[23,34,56],"realistic":[24],"spatio-temporal":[25],"queries,":[26],"where":[27],"success":[28],"requires":[29],"aligning":[30],"vague":[31],"user":[32],"phrasing":[33],"schema-specific":[35],"categories,":[36],"handling":[37],"temporal":[38],"reasoning,":[39],"and":[40,68,77],"choosing":[41],"appropriate":[42],"outputs.":[43],"We":[44],"present":[45],"an":[46],"agentic":[47],"pipeline":[48],"that":[49],"extends":[50],"a":[51,59],"naive":[52],"text-to-SQL":[53],"baseline":[54],"(defog/llama-3-sqlcoder-8b)":[55],"orchestration":[57],"by":[58],"Mistral-based":[60],"ReAct":[61],"agent.":[62],"The":[63],"agent":[64],"can":[65],"plan,":[66],"decompose,":[67],"adapt":[69],"queries":[70],"through":[71],"schema":[72],"inspection,":[73],"SQL":[74],"generation,":[75],"execution,":[76],"visualization":[78],"tools.":[79]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-08-18T07:49:30.821534","created_date":"2025-10-30T00:00:00"}