{"id":"https://openalex.org/W4384615768","doi":"https://doi.org/10.48550/arxiv.2307.07306","title":"C3: Zero-shot Text-to-SQL with ChatGPT","display_name":"C3: Zero-shot Text-to-SQL with ChatGPT","publication_year":2023,"publication_date":"2023-07-14","ids":{"openalex":"https://openalex.org/W4384615768","doi":"https://doi.org/10.48550/arxiv.2307.07306"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2307.07306","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2307.07306","pdf_url":"https://arxiv.org/pdf/2307.07306","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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"volume":null,"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2307.07306","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061145029","display_name":"Xuemei Dong","orcid":"https://orcid.org/0000-0001-7770-0927","observed_orcids":["https://orcid.org/0000-0001-7770-0927"]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dong, Xuemei","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Zhang, Chao","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhang, Chao","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031320360","display_name":"Yuhang Ge","orcid":"https://orcid.org/0000-0002-2522-1753","observed_orcids":["https://orcid.org/0000-0002-2522-1753"]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ge, Yuhang","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038355914","display_name":"Yuren Mao","orcid":"https://orcid.org/0000-0003-0550-3072","observed_orcids":["https://orcid.org/0000-0003-0550-3072"]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mao, Yuren","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006238145","display_name":"Yunjun Gao","orcid":"https://orcid.org/0000-0003-3816-8450","observed_orcids":["https://orcid.org/0000-0003-3816-8450"]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gao, Yunjun","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100432093","display_name":"Lu Chen","orcid":"https://orcid.org/0000-0002-5685-7017","observed_orcids":["https://orcid.org/0000-0002-5685-7017","https://orcid.org/0000-0002-0532-0973"]},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen, lu","raw_affiliation_strings":["Zhejiang University , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University , Zhejiang , China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078108447","display_name":"Jinshu Lin","orcid":"https://orcid.org/0000-0002-3853-0205","observed_orcids":["https://orcid.org/0000-0002-3853-0205"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lin, Jinshu","raw_affiliation_strings":["Hundsun Technologies INC. , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hundsun Technologies INC. , Zhejiang , China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030513587","display_name":"Dongfang Lou","orcid":"https://orcid.org/0009-0003-3467-6957","observed_orcids":["https://orcid.org/0009-0003-3467-6957"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lou, Dongfang","raw_affiliation_strings":["Hundsun Technologies INC. , Zhejiang , China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hundsun Technologies INC. , Zhejiang , China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":28,"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.5580999851226807,"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.5580999851226807,"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.23010000586509705,"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/T11714","display_name":"Multimodal Machine Learning Applications","score":0.02969999983906746,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/chatgpt","display_name":"ChatGPT","score":0.9929999709129333},{"id":"https://openalex.org/keywords/prompting-strategies","display_name":"prompting strategies","score":0.5540000200271606},{"id":"https://openalex.org/keywords/model-calibration","display_name":"model calibration","score":0.7129999995231628},{"id":"https://openalex.org/keywords/output-consistency","display_name":"output consistency","score":0.6320000290870667},{"id":"https://openalex.org/keywords/large-language-models","display_name":"large language models","score":0.6629999876022339},{"id":"https://openalex.org/keywords/query-generation","display_name":"query generation","score":0.3240000009536743}],"concepts":[{"id":"https://openalex.org/C2780813799","wikidata":"https://www.wikidata.org/wiki/Q3274237","display_name":"Zero (linguistics)","level":2,"score":0.8187315464019775},{"id":"https://openalex.org/C2778344882","wikidata":"https://www.wikidata.org/wiki/Q278938","display_name":"Shot (pellet)","level":2,"score":0.7766912579536438},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7661171555519104},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7236862182617188},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5867910981178284},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.4391302168369293},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.42550337314605713},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4249129593372345},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.407802015542984},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3574201166629791},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.21864137053489685},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1510365903377533},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07385960221290588},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"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}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2307.07306","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2307.07306","pdf_url":"https://arxiv.org/pdf/2307.07306","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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2307.07306","doi":"https://doi.org/10.48550/arxiv.2307.07306","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2307.07306","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:2307.07306","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2307.07306","pdf_url":"https://arxiv.org/pdf/2307.07306","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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4384615768.pdf","grobid_xml":"https://content.openalex.org/works/W4384615768.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4361019453","https://openalex.org/W4414849599","https://openalex.org/W7169563875","https://openalex.org/W7164053223","https://openalex.org/W4417404350","https://openalex.org/W2997970380","https://openalex.org/W3173225835","https://openalex.org/W4388184024","https://openalex.org/W4381326864","https://openalex.org/W4416387211"],"abstract_inverted_index":{"This":[0],"paper":[1],"proposes":[2],"a":[3,68],"ChatGPT-based":[4],"zero-shot":[5,29,72],"Text-to-SQL":[6,30],"method,":[7],"dubbed":[8],"C3,":[9],"which":[10,53],"achieves":[11],"82.3\\%":[12],"in":[13],"terms":[14],"of":[15,23,38,85],"execution":[16],"accuracy":[17],"on":[18,32],"the":[19,27,33,57,81],"holdout":[20],"test":[21],"set":[22],"Spider":[24,34],"and":[25,49,62,83],"becomes":[26],"state-of-the-art":[28],"method":[31],"Challenge.":[35],"C3":[36],"consists":[37],"three":[39],"key":[40],"components:":[41],"Clear":[42],"Prompting":[43],"(CP),":[44],"Calibration":[45],"with":[46],"Hints":[47],"(CH),":[48],"Consistent":[50],"Output":[51],"(CO),":[52],"are":[54],"corresponding":[55],"to":[56,79],"model":[58,60,63],"input,":[59],"bias":[61],"output":[64],"respectively.":[65],"It":[66],"provides":[67],"systematic":[69],"treatment":[70],"for":[71],"Text-to-SQL.":[73],"Extensive":[74],"experiments":[75],"have":[76],"been":[77],"conducted":[78],"verify":[80],"effectiveness":[82],"efficiency":[84],"our":[86],"proposed":[87],"method.":[88]},"counts_by_year":[{"year":2026,"cited_by_count":5},{"year":2025,"cited_by_count":12},{"year":2024,"cited_by_count":10},{"year":2023,"cited_by_count":1}],"updated_date":"2026-10-03T13:16:28.481748","created_date":"2023-07-18T00:00:00"}