{"id":"https://openalex.org/W4402042542","doi":"https://doi.org/10.14778/3681954.3682003","title":"The Dawn of Natural Language to SQL: Are We Fully Ready?","display_name":"The Dawn of Natural Language to SQL: Are We Fully Ready?","publication_year":2024,"publication_date":"2024-07-01","ids":{"openalex":"https://openalex.org/W4402042542","doi":"https://doi.org/10.14778/3681954.3682003"},"language":"en","primary_location":{"id":"doi:10.14778/3681954.3682003","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3681954.3682003","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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":"https://openalex.org/A5113242148","display_name":"Boyan Li","orcid":"https://orcid.org/0009-0001-4662-5124"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Boyan Li","raw_affiliation_strings":["HKUST (GZ)"],"affiliations":[{"raw_affiliation_string":"HKUST (GZ)","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100614732","display_name":"Yuyu Luo","orcid":"https://orcid.org/0000-0001-9530-3327"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Yuyu Luo","raw_affiliation_strings":["HKUST (GZ) / HKUST"],"affiliations":[{"raw_affiliation_string":"HKUST (GZ) / HKUST","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101797040","display_name":"Chengliang Chai","orcid":"https://orcid.org/0000-0001-8080-5594"},"institutions":[{"id":"https://openalex.org/I125839683","display_name":"Beijing Institute of Technology","ror":"https://ror.org/01skt4w74","country_code":"CN","type":"education","lineage":["https://openalex.org/I125839683","https://openalex.org/I890469752"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chengliang Chai","raw_affiliation_strings":["Beijing Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Beijing Institute of Technology","institution_ids":["https://openalex.org/I125839683"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100451576","display_name":"Guoliang Li","orcid":"https://orcid.org/0000-0002-1398-0621"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guoliang Li","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101824160","display_name":"Nan Tang","orcid":"https://orcid.org/0000-0003-2832-0295"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Nan Tang","raw_affiliation_strings":["HKUST (GZ) / HKUST"],"affiliations":[{"raw_affiliation_string":"HKUST (GZ) / HKUST","institution_ids":["https://openalex.org/I200769079"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5113242148"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":16.5658,"has_fulltext":false,"cited_by_count":49,"citation_normalized_percentile":{"value":0.9932686,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"17","issue":"11","first_page":"3318","last_page":"3331"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9994000196456909,"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/T10028","display_name":"Topic Modeling","score":0.9994000196456909,"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.9991000294685364,"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/T10260","display_name":"Software Engineering Research","score":0.9922999739646912,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.8490564823150635},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.760888934135437},{"id":"https://openalex.org/keywords/identification","display_name":"Identification (biology)","score":0.6010921597480774},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.5756248235702515},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5295114517211914},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.4932677149772644},{"id":"https://openalex.org/keywords/space","display_name":"Space (punctuation)","score":0.47373831272125244},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.43034255504608154},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.4275178611278534},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4112702012062073},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3525005877017975},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3432424068450928},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.22925183176994324},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2215328812599182},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.17808109521865845},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.12427777051925659},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09456214308738708},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.07183536887168884}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8490564823150635},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.760888934135437},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.6010921597480774},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.5756248235702515},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5295114517211914},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4932677149772644},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.47373831272125244},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.43034255504608154},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4275178611278534},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4112702012062073},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3525005877017975},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3432424068450928},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.22925183176994324},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2215328812599182},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.17808109521865845},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.12427777051925659},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09456214308738708},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.07183536887168884},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3681954.3682003","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3681954.3682003","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-146053","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-146053","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"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":"Conference paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W2032374895","https://openalex.org/W2795226127","https://openalex.org/W2798990443","https://openalex.org/W2963341956","https://openalex.org/W3012492726","https://openalex.org/W3034999214","https://openalex.org/W3093819145","https://openalex.org/W3103611182","https://openalex.org/W3103801878","https://openalex.org/W3170721718","https://openalex.org/W3170978252","https://openalex.org/W3174906424","https://openalex.org/W3177130063","https://openalex.org/W3200079259","https://openalex.org/W3213578841","https://openalex.org/W3214600982","https://openalex.org/W4281763536","https://openalex.org/W4283733706","https://openalex.org/W4290927888","https://openalex.org/W4317716303","https://openalex.org/W4319862210","https://openalex.org/W4362515116","https://openalex.org/W4375869868","https://openalex.org/W4376167329","https://openalex.org/W4381326864","https://openalex.org/W4382202531","https://openalex.org/W4382202695","https://openalex.org/W4384615768","https://openalex.org/W4384918448","https://openalex.org/W4385570661","https://openalex.org/W4385571380","https://openalex.org/W4385572463","https://openalex.org/W4385573058","https://openalex.org/W4386185625","https://openalex.org/W4389984466","https://openalex.org/W4391272793","https://openalex.org/W4391766565","https://openalex.org/W4392222428","https://openalex.org/W4396571402","https://openalex.org/W4396851234","https://openalex.org/W4402386228"],"related_works":["https://openalex.org/W2383619981","https://openalex.org/W4206687279","https://openalex.org/W4245299004","https://openalex.org/W2809743883","https://openalex.org/W4390861444","https://openalex.org/W4386768611","https://openalex.org/W2340883001","https://openalex.org/W2884764431","https://openalex.org/W4316658535","https://openalex.org/W2557197178"],"abstract_inverted_index":{"Translating":[0],"users'":[1],"natural":[2],"language":[3],"questions":[4],"into":[5],"SQL":[6],"queries":[7],"(":[8],"i.e.":[9],",":[10,66,81,148],"nl2sql)":[11],"significantly":[12],"lowers":[13],"the":[14,55,69,110,121,129,151,155,174],"barriers":[15],"to":[16,47,67,127,137],"accessing":[17],"relational":[18],"databases.":[19],"The":[20],"emergence":[21],"of":[22,73,87,94,131,167],"Large":[23],"Language":[24],"Models":[25],"has":[26],"introduced":[27],"a":[28,40,60,84,92],"novel":[29],"paradigm":[30],"in":[31,51],"nl2sql":[32,49,62,75,89,113,122,134,145],"tasks,":[33],"enhancing":[34],"capabilities":[35],"dramatically.":[36],"However,":[37],"this":[38],"raises":[39],"critical":[41],"question:":[42],"Are":[43],"we":[44,58,82,119],"fully":[45],"prepared":[46],"deploy":[48],"models":[50],"production?":[52],"To":[53],"address":[54],"posed":[56],"questions,":[57],"present":[59],"multi-angle":[61],"evaluation":[63],"framework,":[64],"NL2SQL360":[65,80,126,141],"facilitate":[68],"design":[70,123],"and":[71,102,170,176],"test":[72,178],"new":[74],"methods":[76,90,114],"for":[77,108,115],"researchers.":[78],"Through":[79],"conduct":[83],"detailed":[85],"comparison":[86],"leading":[88],"across":[91],"range":[93],"application":[95],"scenarios,":[96],"such":[97],"as":[98],"different":[99],"data":[100],"domains":[101],"sql":[103],"characteristics,":[104],"offering":[105],"valuable":[106],"insights":[107],"selecting":[109],"most":[111],"appropriate":[112],"specific":[116],"needs.":[117,139],"Moreover,":[118],"explore":[120],"space,":[124],"leveraging":[125],"automate":[128],"identification":[130],"an":[132,143],"optimal":[133],"solution":[135],"tailored":[136],"user-specific":[138],"Specifically,":[140],"identifies":[142],"effective":[144],"method,":[146],"SuperSQL":[147,160],"distinguished":[149],"under":[150],"Spider":[152,175],"dataset":[153],"using":[154],"execution":[156,165],"accuracy":[157,166],"metric.":[158],"Remarkably,":[159],"achieves":[161],"competitive":[162],"performance":[163],"with":[164],"87":[168],"%":[169,172],"62.66":[171],"on":[173],"BIRD":[177],"sets,":[179],"respectively.":[180]},"counts_by_year":[{"year":2026,"cited_by_count":9},{"year":2025,"cited_by_count":40}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2025-10-10T00:00:00"}