{"id":"https://openalex.org/W7081978817","doi":"https://doi.org/10.1109/tkde.2025.3609486","title":"Next-Generation Database Interfaces: A Survey of LLM-Based Text-to-SQL","display_name":"Next-Generation Database Interfaces: A Survey of LLM-Based Text-to-SQL","publication_year":2025,"publication_date":"2025-09-12","ids":{"openalex":"https://openalex.org/W7081978817","doi":"https://doi.org/10.1109/tkde.2025.3609486"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2025.3609486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2025.3609486","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Zijin Hong","orcid":"https://orcid.org/0009-0008-2283-255X"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Zijin Hong","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, SAR, China"],"raw_orcid":"https://orcid.org/0009-0008-2283-255X","affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, SAR, China","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Zheng Yuan","orcid":"https://orcid.org/0009-0000-9231-2607"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Zheng Yuan","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, SAR, China"],"raw_orcid":"https://orcid.org/0009-0000-9231-2607","affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, SAR, China","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Qinggang Zhang","orcid":"https://orcid.org/0000-0002-0247-4942"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Qinggang Zhang","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, SAR, China"],"raw_orcid":"https://orcid.org/0000-0002-0247-4942","affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, SAR, China","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Hao Chen","orcid":"https://orcid.org/0000-0001-6816-5344"},"institutions":[{"id":"https://openalex.org/I6469544","display_name":"City University of Macau","ror":"https://ror.org/04gpd4q15","country_code":"MO","type":"education","lineage":["https://openalex.org/I6469544"]}],"countries":["MO"],"is_corresponding":false,"raw_author_name":"Hao Chen","raw_affiliation_strings":["City University of Macau, Macau SAR, China"],"raw_orcid":"https://orcid.org/0000-0001-6816-5344","affiliations":[{"raw_affiliation_string":"City University of Macau, Macau SAR, China","institution_ids":["https://openalex.org/I6469544"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Junnan Dong","orcid":"https://orcid.org/0000-0003-2117-6083"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Junnan Dong","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, SAR, China"],"raw_orcid":"https://orcid.org/0000-0003-2117-6083","affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, SAR, China","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Feiran Huang","orcid":"https://orcid.org/0000-0003-4294-0212"},"institutions":[{"id":"https://openalex.org/I159948400","display_name":"Jinan University","ror":"https://ror.org/02xe5ns62","country_code":"CN","type":"education","lineage":["https://openalex.org/I159948400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Feiran Huang","raw_affiliation_strings":["Jinan University, Guangzhou, China"],"raw_orcid":"https://orcid.org/0000-0003-4294-0212","affiliations":[{"raw_affiliation_string":"Jinan University, Guangzhou, China","institution_ids":["https://openalex.org/I159948400"]}]},{"author_position":"last","author":{"id":null,"display_name":"Xiao Huang","orcid":"https://orcid.org/0000-0002-3867-900X"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Xiao Huang","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, SAR, China"],"raw_orcid":"https://orcid.org/0000-0002-3867-900X","affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, SAR, China","institution_ids":["https://openalex.org/I14243506"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":63.0264,"has_fulltext":false,"cited_by_count":45,"citation_normalized_percentile":{"value":0.99912017,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"37","issue":"12","first_page":"7328","last_page":"7345"},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T12157","display_name":"Geochemistry and Geologic Mapping","score":0.7024999856948853,"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/T12157","display_name":"Geochemistry and Geologic Mapping","score":0.7024999856948853,"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/T13067","display_name":"Geological Modeling and Analysis","score":0.027899999171495438,"subfield":{"id":"https://openalex.org/subfields/1906","display_name":"Geochemistry and Petrology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T14311","display_name":"Electrical and Electromagnetic Research","score":0.01600000075995922,"subfield":{"id":"https://openalex.org/subfields/3107","display_name":"Atomic and Molecular Physics, and Optics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5802000164985657},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.5468999743461609},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4936000108718872},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.48159998655319214},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4708000123500824},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.46779999136924744},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4494999945163727}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8690000176429749},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5802000164985657},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5468999743461609},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4936000108718872},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.48159998655319214},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4708000123500824},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.46779999136924744},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4494999945163727},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42640000581741333},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.39070001244544983},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3686999976634979},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3450999855995178},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.34130001068115234},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.31450000405311584},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.29120001196861267},{"id":"https://openalex.org/C2776187449","wikidata":"https://www.wikidata.org/wiki/Q1513879","display_name":"Natural language generation","level":3,"score":0.28029999136924744},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.26840001344680786},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.25870001316070557},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2549000084400177}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2025.3609486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2025.3609486","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G6125932922","display_name":null,"funder_award_id":"62502008","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":80,"referenced_works":["https://openalex.org/W2064675550","https://openalex.org/W2269738476","https://openalex.org/W2287859124","https://openalex.org/W2890431379","https://openalex.org/W2896457183","https://openalex.org/W2945102109","https://openalex.org/W2963323070","https://openalex.org/W2963477458","https://openalex.org/W2963748441","https://openalex.org/W2970442801","https://openalex.org/W2970605129","https://openalex.org/W3035231859","https://openalex.org/W3042609801","https://openalex.org/W3093819145","https://openalex.org/W3102095584","https://openalex.org/W3104196282","https://openalex.org/W3104917146","https://openalex.org/W3106221893","https://openalex.org/W3150263485","https://openalex.org/W3152884768","https://openalex.org/W3160638507","https://openalex.org/W3170978252","https://openalex.org/W3175818566","https://openalex.org/W3199077625","https://openalex.org/W3201174429","https://openalex.org/W3214600982","https://openalex.org/W4210716649","https://openalex.org/W4229022682","https://openalex.org/W4283733706","https://openalex.org/W4285195848","https://openalex.org/W4285244831","https://openalex.org/W4317716303","https://openalex.org/W4365512576","https://openalex.org/W4382202531","https://openalex.org/W4382202695","https://openalex.org/W4385245566","https://openalex.org/W4385281245","https://openalex.org/W4385565008","https://openalex.org/W4385570661","https://openalex.org/W4385572707","https://openalex.org/W4385572825","https://openalex.org/W4385573280","https://openalex.org/W4388551928","https://openalex.org/W4388639106","https://openalex.org/W4389518797","https://openalex.org/W4389519829","https://openalex.org/W4389520779","https://openalex.org/W4389523781","https://openalex.org/W4389523875","https://openalex.org/W4389523899","https://openalex.org/W4389524197","https://openalex.org/W4391883497","https://openalex.org/W4392240262","https://openalex.org/W4393156804","https://openalex.org/W4396571402","https://openalex.org/W4396886508","https://openalex.org/W4398234583","https://openalex.org/W4399175046","https://openalex.org/W4400525841","https://openalex.org/W4400909496","https://openalex.org/W4400909566","https://openalex.org/W4401043375","https://openalex.org/W4402042542","https://openalex.org/W4402667093","https://openalex.org/W4402670079","https://openalex.org/W4402670291","https://openalex.org/W4402670984","https://openalex.org/W4402671672","https://openalex.org/W4402683779","https://openalex.org/W4402684119","https://openalex.org/W4404239715","https://openalex.org/W4404782394","https://openalex.org/W4404782579","https://openalex.org/W4404782868","https://openalex.org/W4410202262","https://openalex.org/W4411119477","https://openalex.org/W4412130408","https://openalex.org/W4412158322","https://openalex.org/W4412944059","https://openalex.org/W4412945394"],"related_works":[],"abstract_inverted_index":{"Generating":[0],"accurate":[1],"SQL":[2,26],"from":[3],"users\u2019":[4],"natural":[5,102],"language":[6,45,94,103],"questions":[7,63],"(text-to-SQL)":[8],"remains":[9],"a":[10,69,128,139,166,178],"long-standing":[11],"challenge":[12],"due":[13],"to":[14,120,159],"the":[15,87,143,154,182],"complexities":[16],"involved":[17],"in":[18,101,172,185],"user":[19,62],"question":[20],"understanding,":[21],"database":[22],"schema":[23],"comprehension,":[24],"and":[25,35,61,81,118,146,156,180,188],"generation.":[27],"Traditional":[28],"text-to-SQL":[29,52,121,134,161],"systems,":[30],"which":[31,85],"combine":[32],"human":[33],"engineering":[34],"deep":[36],"neural":[37],"networks,":[38],"have":[39,48,97],"made":[40],"significant":[41,99],"progress.":[42],"Subsequently,":[43,163],"pre-trained":[44],"models":[46,95],"(PLMs)":[47],"been":[49],"developed":[50],"for":[51,191],"tasks,":[53],"achieving":[54],"promising":[55],"results.":[56],"However,":[57],"as":[58,105],"modern":[59],"databases":[60],"grow":[64],"more":[65,79],"complex,":[66],"PLMs":[67],"with":[68],"limited":[70],"parameter":[71],"size":[72],"often":[73],"produce":[74],"incorrect":[75],"SQL.":[76],"This":[77],"necessitates":[78],"sophisticated":[80],"tailored":[82],"optimization":[83],"methods,":[84],"restrict":[86],"application":[88],"of":[89,131,142,149,169],"PLM-based":[90],"systems.":[91,162],"Recently,":[92],"large":[93],"(LLMs)":[96],"shown":[98],"capabilities":[100],"understanding":[104],"model":[106],"scale":[107],"increases.":[108],"Thus,":[109],"integrating":[110],"LLM-based":[111,133,173],"solutions":[112,119],"can":[113],"bring":[114],"unique":[115],"opportunities,":[116],"improvements,":[117],"research.":[122],"In":[123],"this":[124,186],"survey,":[125],"we":[126,137,152,164,176],"provide":[127],"comprehensive":[129],"review":[130],"existing":[132],"studies.":[135],"Specifically,":[136],"offer":[138],"brief":[140],"overview":[141],"technical":[144],"challenges":[145,184],"evolutionary":[147],"process":[148],"text-to-SQL.":[150,174],"Next,":[151],"introduce":[153],"datasets":[155],"metrics":[157],"designed":[158],"evaluate":[160],"present":[165],"systematic":[167],"analysis":[168],"recent":[170],"advances":[171],"Finally,":[175],"make":[177],"summary":[179],"discuss":[181],"remaining":[183],"field":[187],"suggest":[189],"expectations":[190],"future":[192],"research":[193],"directions.":[194]},"counts_by_year":[{"year":2026,"cited_by_count":22},{"year":2025,"cited_by_count":23}],"updated_date":"2026-07-11T18:08:03.149640","created_date":"2025-10-10T00:00:00"}