{"id":"https://openalex.org/W4403854021","doi":"https://doi.org/10.48550/arxiv.2410.01943","title":"CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL","display_name":"CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL","publication_year":2024,"publication_date":"2024-10-02","ids":{"openalex":"https://openalex.org/W4403854021","doi":"https://doi.org/10.48550/arxiv.2410.01943"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2410.01943","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2410.01943","pdf_url":"https://arxiv.org/pdf/2410.01943","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"volume":null,"type":"preprint","is_traditional":true,"indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2410.01943","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5070837833","display_name":"Mohammadreza Pourreza","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pourreza, Mohammadreza","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Li, Hailong","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Li, Hailong","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102776191","display_name":"Ruoxi Sun","orcid":"https://orcid.org/0000-0002-4430-3279","observed_orcids":["https://orcid.org/0000-0002-4430-3279"]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sun, Ruoxi","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087758743","display_name":"Yeounoh Chung","orcid":"https://orcid.org/0009-0004-3947-2782","observed_orcids":["https://orcid.org/0009-0004-3947-2782","https://orcid.org/0000-0002-6535-9001"]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chung, Yeounoh","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5098921497","display_name":"Shayan Talaei","orcid":"https://orcid.org/0009-0005-6697-8487","observed_orcids":["https://orcid.org/0009-0005-6697-8487"]},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Talaei, Shayan","raw_affiliation_strings":["Stanford University , Stanford , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University , Stanford , CA , USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075392841","display_name":"Gaurav Tarlok Kakkar","orcid":"https://orcid.org/0000-0003-2750-5052","observed_orcids":["https://orcid.org/0000-0003-2750-5052"]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kakkar, Gaurav Tarlok","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108145223","display_name":"Yu Gan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gan, Yu","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001035442","display_name":"Amin Saberi","orcid":"https://orcid.org/0000-0002-7043-0722","observed_orcids":["https://orcid.org/0000-0002-7043-0722","https://orcid.org/0000-0001-5255-4150"]},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Saberi, Amin","raw_affiliation_strings":["Stanford University , Stanford , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University , Stanford , CA , USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070638387","display_name":"Fatma \u00d6zcan","orcid":"https://orcid.org/0000-0002-4418-4724","observed_orcids":["https://orcid.org/0000-0002-4418-4724"]},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ozcan, Fatma","raw_affiliation_strings":["Google Cloud , Sunnyvale , CA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Cloud , Sunnyvale , CA , USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037420650","display_name":"Sercan \u00d6. Ar\u0131k","orcid":"https://orcid.org/0000-0001-6333-1729","observed_orcids":["https://orcid.org/0000-0001-6333-1729"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Arik, Sercan O.","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":156,"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/T10028","display_name":"Topic Modeling","score":0.3529999852180481,"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.3529999852180481,"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.31299999356269836,"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.08590000122785568,"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/text-to-sql","display_name":"text-to-SQL","score":0.8679999709129333},{"id":"https://openalex.org/keywords/multi-agent-systems","display_name":"multi-agent systems","score":0.546999990940094},{"id":"https://openalex.org/keywords/candidate-selection","display_name":"candidate selection","score":0.7120000123977661},{"id":"https://openalex.org/keywords/chain-of-thought-reasoning","display_name":"chain-of-thought reasoning","score":0.8389999866485596},{"id":"https://openalex.org/keywords/query-decomposition","display_name":"query decomposition","score":0.8519999980926514},{"id":"https://openalex.org/keywords/few-shot-learning","display_name":"few-shot learning","score":0.6769999861717224}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7170323729515076},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6869427561759949},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.6606602072715759},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6454377174377441},{"id":"https://openalex.org/C2781249084","wikidata":"https://www.wikidata.org/wiki/Q908656","display_name":"Preference","level":2,"score":0.5030681490898132},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4149578809738159},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3468087315559387},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32649850845336914},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2830018401145935},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2827155590057373},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.234818696975708},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.16372153162956238},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15360236167907715},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09125688672065735},{"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:2410.01943","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2410.01943","pdf_url":"https://arxiv.org/pdf/2410.01943","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2410.01943","doi":"https://doi.org/10.48550/arxiv.2410.01943","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2410.01943","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2410.01943","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2410.01943","pdf_url":"https://arxiv.org/pdf/2410.01943","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4403854021.pdf","grobid_xml":"https://content.openalex.org/works/W4403854021.grobid-xml"},"referenced_works_count":25,"referenced_works":["https://openalex.org/W2912624765","https://openalex.org/W2952380375","https://openalex.org/W2985377636","https://openalex.org/W3014265582","https://openalex.org/W3035231859","https://openalex.org/W3091229675","https://openalex.org/W3175488485","https://openalex.org/W3177813494","https://openalex.org/W4285227295","https://openalex.org/W4365205411","https://openalex.org/W4379258895","https://openalex.org/W4382202695","https://openalex.org/W4384615768","https://openalex.org/W4385570661","https://openalex.org/W4385572634","https://openalex.org/W4387725609","https://openalex.org/W4389984466","https://openalex.org/W4396571402","https://openalex.org/W4396913744","https://openalex.org/W4399115971","https://openalex.org/W4402042542","https://openalex.org/W4402502803","https://openalex.org/W4402698825","https://openalex.org/W4404782579","https://openalex.org/W7133224126"],"related_works":["https://openalex.org/W4415348225","https://openalex.org/W4396571402","https://openalex.org/W4396913744","https://openalex.org/W4411120059","https://openalex.org/W4390647423","https://openalex.org/W4404467346","https://openalex.org/W7134954916","https://openalex.org/W4379258895","https://openalex.org/W4416023991","https://openalex.org/W4412945149"],"abstract_inverted_index":{"In":[0],"tackling":[1],"the":[2,77,104,114,144,161,170,177,185,189,192],"challenges":[3],"of":[4,148,165,176,188,194],"large":[5],"language":[6],"model":[7],"(LLM)":[8],"performance":[9],"for":[10],"Text-to-SQL":[11,180],"tasks,":[12],"we":[13],"introduce":[14],"CHASE-SQL,":[15],"a":[16,53,64,79,87,107,120],"new":[17],"framework":[18,140],"that":[19,56],"employs":[20],"innovative":[21],"strategies,":[22],"using":[23,47],"test-time":[24],"compute":[25],"in":[26,63],"multi-agent":[27],"modeling":[28],"to":[29,40,100,112,131],"improve":[30],"candidate":[31],"generation":[32,92],"and":[33,43,85,146,167,173],"selection.":[34],"CHASE-SQL":[35,159,184],"leverages":[36],"LLMs'":[37],"intrinsic":[38],"knowledge":[39],"generate":[41],"diverse":[42],"high-quality":[44],"SQL":[45,149],"candidates":[46,115],"different":[48],"LLM":[49,66],"generators":[50],"with:":[51],"(1)":[52],"divide-and-conquer":[54],"method":[55],"decomposes":[57],"complex":[58],"queries":[59,150],"into":[60],"manageable":[61],"sub-queries":[62],"single":[65],"call;":[67],"(2)":[68],"chain-of-thought":[69],"reasoning":[70],"based":[71],"on":[72,169],"query":[73],"execution":[74,163],"plans,":[75],"reflecting":[76],"steps":[78],"database":[80],"engine":[81],"takes":[82],"during":[83],"execution;":[84],"(3)":[86],"unique":[88],"instance-aware":[89],"synthetic":[90],"example":[91],"technique,":[93],"which":[94],"offers":[95],"specific":[96],"few-shot":[97],"demonstrations":[98],"tailored":[99],"test":[101,171],"questions.To":[102],"identify":[103],"best":[105],"candidate,":[106],"selection":[108,123,126],"agent":[109],"is":[110],"employed":[111],"rank":[113],"through":[116],"pairwise":[117],"comparisons":[118],"with":[119],"fine-tuned":[121],"binary-candidates":[122],"LLM.":[124],"This":[125],"approach":[127],"has":[128],"been":[129],"demonstrated":[130],"be":[132],"more":[133],"robust":[134],"over":[135],"alternatives.":[136],"The":[137],"proposed":[138,158],"generators-selector":[139],"not":[141],"only":[142],"enhances":[143],"quality":[145],"diversity":[147],"but":[151],"also":[152],"outperforms":[153],"previous":[154],"methods.":[155],"Overall,":[156],"our":[157],"achieves":[160],"state-of-the-art":[162],"accuracy":[164],"73.0%":[166],"73.01%":[168],"set":[172,175],"development":[174],"notable":[178],"BIRD":[179],"dataset":[181],"benchmark,":[182],"rendering":[183],"top":[186],"submission":[187],"leaderboard":[190],"(at":[191],"time":[193],"paper":[195],"submission).":[196]},"counts_by_year":[{"year":2026,"cited_by_count":73},{"year":2025,"cited_by_count":74},{"year":2024,"cited_by_count":8},{"year":2017,"cited_by_count":1}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2024-10-30T00:00:00"}