{"id":"https://openalex.org/W4399657792","doi":"https://doi.org/10.48550/arxiv.2406.08426","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":2024,"publication_date":"2024-06-12","ids":{"openalex":"https://openalex.org/W4399657792","doi":"https://doi.org/10.48550/arxiv.2406.08426"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2406.08426","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2406.08426","pdf_url":"https://arxiv.org/pdf/2406.08426","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2406.08426","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101383081","display_name":"Zijin Hong","orcid":"https://orcid.org/0009-0008-2283-255X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Hong, Zijin","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102358838","display_name":"Zheng Yuan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yuan, Zheng","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058417704","display_name":"Qinggang Zhang","orcid":"https://orcid.org/0000-0002-1536-6529"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Qinggang","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100771561","display_name":"Hao Chen","orcid":"https://orcid.org/0000-0003-0482-8940"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Hao","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038326486","display_name":"Junnan Dong","orcid":"https://orcid.org/0000-0003-2117-6083"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dong, Junnan","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033233243","display_name":"Feiran Huang","orcid":"https://orcid.org/0000-0003-4294-0212"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Huang, Feiran","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5001290903","display_name":"Xiao Huang","orcid":"https://orcid.org/0009-0004-6985-6648"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Huang, Xiao","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5101383081"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":11,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.946399986743927,"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/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.946399986743927,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9090999960899353,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6763149499893188},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6170987486839294},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.6139718890190125},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6074025630950928},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5247429013252258},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5029911398887634},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.288568913936615},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.22678163647651672},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.0485367476940155}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6763149499893188},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6170987486839294},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6139718890190125},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6074025630950928},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5247429013252258},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5029911398887634},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.288568913936615},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22678163647651672},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0485367476940155},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2406.08426","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2406.08426","pdf_url":"https://arxiv.org/pdf/2406.08426","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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"},{"id":"doi:10.48550/arxiv.2406.08426","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2406.08426","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2406.08426","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2406.08426","pdf_url":"https://arxiv.org/pdf/2406.08426","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"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"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G384178317","display_name":null,"funder_award_id":"02008","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"},{"id":"https://openalex.org/F4320322598","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98"},{"id":"https://openalex.org/F4320323893","display_name":"Fundo para o Desenvolvimento das Ci\u00eancias e da Tecnologia","ror":"https://ror.org/05vna4324"}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4399657792.pdf"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W4386768611","https://openalex.org/W1554917839","https://openalex.org/W2340883001","https://openalex.org/W2884764431","https://openalex.org/W650213220","https://openalex.org/W91546718","https://openalex.org/W42614002","https://openalex.org/W2183714398","https://openalex.org/W7869049"],"abstract_inverted_index":{"Generating":[0],"accurate":[1],"SQL":[2,26],"from":[3],"users'":[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,196,211],"complexities":[16],"involved":[17],"in":[18,101,172,185,213],"user":[19,62],"question":[20],"understanding,":[21],"database":[22],"schema":[23],"comprehension,":[24],"and":[25,35,61,81,118,146,156,180,188,205],"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,210],"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],"restricts":[86],"application":[88],"of":[89,131,142,149,169,199],"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],"summarization":[179],"discuss":[181],"remaining":[183],"field":[187],"suggest":[189],"expectations":[190],"future":[192],"research":[193,202],"directions.":[194],"All":[195],"related":[197],"resources":[198],"LLM-based,":[200],"including":[201],"papers,":[203],"benchmarks,":[204],"open-source":[206],"projects,":[207],"are":[208],"collected":[209],"community":[212],"our":[214],"repository:":[215],"https://github.com/DEEP-PolyU/Awesome-LLM-based-Text2SQL.":[216]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":3}],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}