{"id":"https://openalex.org/W4317716303","doi":"https://doi.org/10.1007/s00778-022-00776-8","title":"A survey on deep learning approaches for text-to-SQL","display_name":"A survey on deep learning approaches for text-to-SQL","publication_year":2023,"publication_date":"2023-01-23","ids":{"openalex":"https://openalex.org/W4317716303","doi":"https://doi.org/10.1007/s00778-022-00776-8"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-022-00776-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-022-00776-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-022-00776-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s00778-022-00776-8.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5027131827","display_name":"George Katsogiannis-Meimarakis","orcid":"https://orcid.org/0000-0001-8285-5827"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"George Katsogiannis-Meimarakis","raw_affiliation_strings":["Athena Research Center, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Athena Research Center, Athens, Greece","institution_ids":["https://openalex.org/I4210156054"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012623045","display_name":"Georgia Koutrika","orcid":"https://orcid.org/0000-0002-7377-0116"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Georgia Koutrika","raw_affiliation_strings":["Athena Research Center, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Athena Research Center, Athens, Greece","institution_ids":["https://openalex.org/I4210156054"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5027131827"],"corresponding_institution_ids":["https://openalex.org/I4210156054"],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":{"value":2890,"currency":"USD","value_usd":2890},"fwci":20.2932,"has_fulltext":true,"cited_by_count":144,"citation_normalized_percentile":{"value":0.99559685,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"32","issue":"4","first_page":"905","last_page":"936"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9994999766349792,"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.9994999766349792,"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/T11719","display_name":"Data Quality and Management","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9984999895095825,"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.8063890933990479},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6621554493904114},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5227368474006653},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5074717402458191},{"id":"https://openalex.org/keywords/holy-grail","display_name":"Holy Grail","score":0.49522796273231506},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.4292069375514984},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.36551374197006226},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.29479414224624634},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2738470435142517},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09858572483062744}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8063890933990479},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6621554493904114},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5227368474006653},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5074717402458191},{"id":"https://openalex.org/C2781270358","wikidata":"https://www.wikidata.org/wiki/Q5885594","display_name":"Holy Grail","level":2,"score":0.49522796273231506},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4292069375514984},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.36551374197006226},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.29479414224624634},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2738470435142517},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09858572483062744},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s00778-022-00776-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-022-00776-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-022-00776-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1007/s00778-022-00776-8","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-022-00776-8","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-022-00776-8.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G6439140935","display_name":"INODE -  Intelligent Open Data Exploration","funder_award_id":"863410","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4317716303.pdf"},"referenced_works_count":82,"referenced_works":["https://openalex.org/W1902237438","https://openalex.org/W1970709149","https://openalex.org/W2047237057","https://openalex.org/W2066792529","https://openalex.org/W2083619093","https://openalex.org/W2084961399","https://openalex.org/W2091671846","https://openalex.org/W2098388305","https://openalex.org/W2117461391","https://openalex.org/W2142912368","https://openalex.org/W2145618437","https://openalex.org/W2148942721","https://openalex.org/W2153710242","https://openalex.org/W2165382777","https://openalex.org/W2250539671","https://openalex.org/W2589660030","https://openalex.org/W2612518573","https://openalex.org/W2626990892","https://openalex.org/W2757361303","https://openalex.org/W2762513422","https://openalex.org/W2763039547","https://openalex.org/W2798663534","https://openalex.org/W2799072540","https://openalex.org/W2886983157","https://openalex.org/W2890431379","https://openalex.org/W2890867094","https://openalex.org/W2891691255","https://openalex.org/W2944898795","https://openalex.org/W2945102109","https://openalex.org/W2950067395","https://openalex.org/W2952032096","https://openalex.org/W2953192040","https://openalex.org/W2962713807","https://openalex.org/W2963341956","https://openalex.org/W2963357517","https://openalex.org/W2963477458","https://openalex.org/W2963617989","https://openalex.org/W2963794306","https://openalex.org/W2963854351","https://openalex.org/W2963899988","https://openalex.org/W2963993485","https://openalex.org/W2964271186","https://openalex.org/W2970442801","https://openalex.org/W2971323043","https://openalex.org/W2983504480","https://openalex.org/W3022196370","https://openalex.org/W3032035922","https://openalex.org/W3032766766","https://openalex.org/W3034835156","https://openalex.org/W3034999214","https://openalex.org/W3035231859","https://openalex.org/W3046744391","https://openalex.org/W3084548155","https://openalex.org/W3086973390","https://openalex.org/W3101096381","https://openalex.org/W3103801878","https://openalex.org/W3104003456","https://openalex.org/W3104055253","https://openalex.org/W3104196282","https://openalex.org/W3115585256","https://openalex.org/W3115880855","https://openalex.org/W3118268131","https://openalex.org/W3134503905","https://openalex.org/W3150263485","https://openalex.org/W3160974509","https://openalex.org/W3168999116","https://openalex.org/W3170656151","https://openalex.org/W3170978252","https://openalex.org/W3173458274","https://openalex.org/W3175488485","https://openalex.org/W3175818566","https://openalex.org/W3176472386","https://openalex.org/W3177130063","https://openalex.org/W3185858112","https://openalex.org/W3196614708","https://openalex.org/W3199077625","https://openalex.org/W3214600982","https://openalex.org/W4210287336","https://openalex.org/W4224239544","https://openalex.org/W4230471358","https://openalex.org/W4285227295","https://openalex.org/W6608502964"],"related_works":["https://openalex.org/W2368606217","https://openalex.org/W2380770581","https://openalex.org/W1598481744","https://openalex.org/W2374743559","https://openalex.org/W2385759489","https://openalex.org/W50955165","https://openalex.org/W2359324206","https://openalex.org/W2379700889","https://openalex.org/W2389309370","https://openalex.org/W2367232817"],"abstract_inverted_index":{"Abstract":[0],"To":[1,59],"bridge":[2],"the":[3,40,87,116,145,156],"gap":[4],"between":[5,132],"users":[6,17],"and":[7,52,57,77],"data,":[8],"numerous":[9],"text-to-SQL":[10,28,65,106],"systems":[11,29,107],"have":[12],"been":[13,73],"developed":[14],"that":[15,108],"allow":[16,125],"to":[18,69,99,127,150],"pose":[19],"natural":[20],"language":[21],"questions":[22],"over":[23],"relational":[24],"databases.":[25],"Recently,":[26],"novel":[27],"are":[30],"adopting":[31],"deep":[32],"learning":[33],"methods":[34],"with":[35],"very":[36],"promising":[37],"results.":[38],"At":[39],"same":[41],"time,":[42],"several":[43],"challenges":[44,89,140],"remain":[45],"open":[46],"making":[47],"this":[48,96],"area":[49],"an":[50],"active":[51],"flourishing":[53],"field":[54],"of":[55,91,95,104,114,118,144,159],"research":[56,88],"development.":[58],"make":[60,128],"real":[61],"progress":[62],"in":[63,141],"building":[64],"systems,":[66],"we":[67],"need":[68],"de-mystify":[70],"what":[71],"has":[72],"done,":[74],"understand":[75],"how":[76],"when":[78],"each":[79,142],"approach":[80],"can":[81],"be":[82],"used,":[83],"and,":[84],"finally,":[85],"identify":[86],"ahead":[90],"us.":[92],"The":[93],"purpose":[94],"survey":[97],"is":[98],"present":[100],"a":[101,111,120,129],"detailed":[102],"taxonomy":[103,123],"neural":[105],"will":[109,124],"enable":[110],"deeper":[112],"study":[113],"all":[115],"parts":[117],"such":[119],"system.":[121],"This":[122],"us":[126],"better":[130,151],"comparison":[131],"different":[133],"approaches,":[134],"as":[135,137],"well":[136],"highlight":[138],"specific":[139],"step":[143],"process,":[146],"thus":[147],"enabling":[148],"researchers":[149],"strategise":[152],"their":[153],"quest":[154],"towards":[155],"\u201choly":[157],"grail\u201d":[158],"database":[160],"accessibility.":[161]},"counts_by_year":[{"year":2026,"cited_by_count":29},{"year":2025,"cited_by_count":63},{"year":2024,"cited_by_count":35},{"year":2023,"cited_by_count":17}],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}