{"id":"https://openalex.org/W4372265458","doi":"https://doi.org/10.1109/icassp49357.2023.10096170","title":"Conversational Text-to-SQL: An Odyssey into State-of-the-Art and Challenges Ahead","display_name":"Conversational Text-to-SQL: An Odyssey into State-of-the-Art and Challenges Ahead","publication_year":2023,"publication_date":"2023-05-05","ids":{"openalex":"https://openalex.org/W4372265458","doi":"https://doi.org/10.1109/icassp49357.2023.10096170"},"language":"en","primary_location":{"id":"doi:10.1109/icassp49357.2023.10096170","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icassp49357.2023.10096170","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ICASSP 2023 - 2023 IEEE International Conference on Acoustics, Speech and Signal Processing (ICASSP)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5080341961","display_name":"Sree Hari Krishnan Parthasarathi","orcid":null},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sree Hari Krishnan Parthasarathi","raw_affiliation_strings":["Amazon,Alexa AI","Alexa AI, Amazon"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon,Alexa AI","institution_ids":["https://openalex.org/I1311688040"]},{"raw_affiliation_string":"Alexa AI, Amazon","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038254113","display_name":"Lu Zeng","orcid":"https://orcid.org/0000-0002-3247-3844"},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lu Zeng","raw_affiliation_strings":["Amazon,Alexa AI","Alexa AI, Amazon"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon,Alexa AI","institution_ids":["https://openalex.org/I1311688040"]},{"raw_affiliation_string":"Alexa AI, Amazon","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015334291","display_name":"Dilek Hakkani-T\u00fcr","orcid":null},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dilek Hakkani-T\u00fcr","raw_affiliation_strings":["Amazon,Alexa AI","Alexa AI, Amazon"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon,Alexa AI","institution_ids":["https://openalex.org/I1311688040"]},{"raw_affiliation_string":"Alexa AI, Amazon","institution_ids":["https://openalex.org/I1311688040"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1311688040"],"apc_list":null,"apc_paid":null,"fwci":1.7423,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.86570324,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"5"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9998000264167786,"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.9998000264167786,"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.9997000098228455,"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.9945999979972839,"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.8734201788902283},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7056889533996582},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.6953743696212769},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5726058483123779},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.5092908143997192},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.4958864152431488},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4514726996421814},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4494946002960205},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.43484658002853394},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.20606449246406555}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8734201788902283},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7056889533996582},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6953743696212769},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5726058483123779},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.5092908143997192},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4958864152431488},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4514726996421814},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4494946002960205},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.43484658002853394},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20606449246406555},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icassp49357.2023.10096170","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icassp49357.2023.10096170","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ICASSP 2023 - 2023 IEEE International Conference on Acoustics, Speech and Signal Processing (ICASSP)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8500000238418579,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W1596986901","https://openalex.org/W2047237057","https://openalex.org/W2163274265","https://openalex.org/W2751448157","https://openalex.org/W2890431379","https://openalex.org/W2963477458","https://openalex.org/W2963617989","https://openalex.org/W2970172141","https://openalex.org/W2970442801","https://openalex.org/W3034835156","https://openalex.org/W3035172316","https://openalex.org/W3043172396","https://openalex.org/W3100058503","https://openalex.org/W3103291908","https://openalex.org/W3103801878","https://openalex.org/W3124687886","https://openalex.org/W3156366114","https://openalex.org/W3173964589","https://openalex.org/W3176057191","https://openalex.org/W3177813494","https://openalex.org/W3214600982","https://openalex.org/W4226278401","https://openalex.org/W4226490385","https://openalex.org/W4288601872","https://openalex.org/W4293819888","https://openalex.org/W4311887664","https://openalex.org/W4319862210","https://openalex.org/W4385572953","https://openalex.org/W6635815790","https://openalex.org/W6684031499","https://openalex.org/W6690725250","https://openalex.org/W6743367031","https://openalex.org/W6758814090","https://openalex.org/W6779862144","https://openalex.org/W6798182279","https://openalex.org/W6810738896","https://openalex.org/W6842258776"],"related_works":["https://openalex.org/W2073713056","https://openalex.org/W3110702597","https://openalex.org/W2078761926","https://openalex.org/W2110441383","https://openalex.org/W2125620709","https://openalex.org/W1498872724","https://openalex.org/W4233149903","https://openalex.org/W4293864700","https://openalex.org/W23253958","https://openalex.org/W2327539013"],"abstract_inverted_index":{"Conversational,":[0],"multi-turn,":[1],"text-to-SQL":[2,49],"(CoSQL)":[3],"tasks":[4,39],"map":[5],"natural":[6],"language":[7,23],"utterances":[8],"in":[9,29,86,91,137],"a":[10,61,66,95,131],"dialogue":[11],"to":[12,117,122],"SQL":[13,139],"queries.":[14],"State-of-the-art":[15],"(SOTA)":[16],"systems":[17],"use":[18],"large,":[19],"pre-trained":[20],"and":[21,65,74,89,124],"finetuned":[22],"models,":[24],"such":[25],"as":[26,70],"the":[27,128],"T5-family,":[28],"conjunction":[30],"with":[31,40,127,140],"constrained":[32],"decoding.":[33],"With":[34],"multi-tasking":[35],"(MT)":[36],"over":[37,47,56,94],"coherent":[38],"discrete":[41],"prompts":[42],"during":[43],"training,":[44],"we":[45,59],"improve":[46],"specialized":[48],"T5-family":[50],"models.":[51],"Based":[52],"on":[53,98],"Oracle":[54],"analyses":[55],"n-best":[57],"hypotheses,":[58],"apply":[60],"query":[62],"plan":[63],"model":[64],"schema":[67],"linking":[68],"algorithm":[69],"rerankers.":[71],"Combining":[72],"MT":[73],"reranking,":[75],"our":[76],"results":[77],"using":[78],"T53B":[79],"show":[80],"absolute":[81],"accuracy":[82],"improvements":[83],"of":[84],"1.0%":[85],"exact":[87],"match":[88,93],"3.4%":[90],"execution":[92],"SOTA":[96],"baseline":[97],"CoSQL.":[99],"While":[100],"these":[101],"gains":[102],"consistently":[103],"manifest":[104],"at":[105],"turn":[106],"level,":[107],"context":[108],"dependent":[109],"turns":[110],"are":[111],"considerably":[112],"harder.":[113],"We":[114],"conduct":[115],"studies":[116],"tease":[118],"apart":[119],"errors":[120],"attributable":[121],"domain":[123],"compositional":[125],"generalization,":[126],"latter":[129],"remaining":[130],"challenge":[132],"for":[133],"multi-turn":[134],"conversations,":[135],"especially":[136],"generating":[138],"unseen":[141],"parse":[142],"trees.":[143]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":2}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}