{"id":"https://openalex.org/W4409362830","doi":"https://doi.org/10.1609/aaai.v39i22.34511","title":"MAGIC: Generating Self-Correction Guideline for In-Context Text-to-SQL","display_name":"MAGIC: Generating Self-Correction Guideline for In-Context Text-to-SQL","publication_year":2025,"publication_date":"2025-04-11","ids":{"openalex":"https://openalex.org/W4409362830","doi":"https://doi.org/10.1609/aaai.v39i22.34511"},"language":"en","primary_location":{"id":"doi:10.1609/aaai.v39i22.34511","is_oa":true,"landing_page_url":"https://doi.org/10.1609/aaai.v39i22.34511","pdf_url":"https://ojs.aaai.org/index.php/AAAI/article/download/34511/36666","source":{"id":"https://openalex.org/S4210191458","display_name":"Proceedings of the AAAI Conference on Artificial Intelligence","issn_l":"2159-5399","issn":["2159-5399","2374-3468"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310320058","host_organization_name":"Association for the Advancement of Artificial Intelligence","host_organization_lineage":["https://openalex.org/P4310320058"],"host_organization_lineage_names":["Association for the Advancement of Artificial Intelligence"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the AAAI Conference on Artificial Intelligence","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ojs.aaai.org/index.php/AAAI/article/download/34511/36666","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059759006","display_name":"Arian Askari","orcid":"https://orcid.org/0000-0003-4712-832X"},"institutions":[{"id":"https://openalex.org/I121797337","display_name":"Leiden University","ror":"https://ror.org/027bh9e22","country_code":"NL","type":"education","lineage":["https://openalex.org/I121797337"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Arian Askari","raw_affiliation_strings":["Leiden University"],"affiliations":[{"raw_affiliation_string":"Leiden University","institution_ids":["https://openalex.org/I121797337"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021666303","display_name":"Christian Poelitz","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Christian Poelitz","raw_affiliation_strings":["Research, Microsoft"],"affiliations":[{"raw_affiliation_string":"Research, Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113258509","display_name":"Xinye Tang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Xinye Tang","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5059759006"],"corresponding_institution_ids":["https://openalex.org/I121797337"],"apc_list":null,"apc_paid":null,"fwci":22.3761,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":{"value":1.0,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"39","issue":"22","first_page":"23433","last_page":"23441"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9315999746322632,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9315999746322632,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9251999855041504,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9222999811172485,"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/magic","display_name":"MAGIC (telescope)","score":0.6807560920715332},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.576158881187439},{"id":"https://openalex.org/keywords/guideline","display_name":"Guideline","score":0.5470635890960693},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5344976782798767},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5163315534591675},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3825380504131317},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.34698328375816345},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.3409290611743927},{"id":"https://openalex.org/keywords/medicine","display_name":"Medicine","score":0.19235408306121826},{"id":"https://openalex.org/keywords/history","display_name":"History","score":0.15930858254432678},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.13943138718605042}],"concepts":[{"id":"https://openalex.org/C2777704519","wikidata":"https://www.wikidata.org/wiki/Q45732","display_name":"MAGIC (telescope)","level":2,"score":0.6807560920715332},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.576158881187439},{"id":"https://openalex.org/C2780182762","wikidata":"https://www.wikidata.org/wiki/Q1630279","display_name":"Guideline","level":2,"score":0.5470635890960693},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5344976782798767},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5163315534591675},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3825380504131317},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.34698328375816345},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3409290611743927},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.19235408306121826},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.15930858254432678},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.13943138718605042},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1609/aaai.v39i22.34511","is_oa":true,"landing_page_url":"https://doi.org/10.1609/aaai.v39i22.34511","pdf_url":"https://ojs.aaai.org/index.php/AAAI/article/download/34511/36666","source":{"id":"https://openalex.org/S4210191458","display_name":"Proceedings of the AAAI Conference on Artificial Intelligence","issn_l":"2159-5399","issn":["2159-5399","2374-3468"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310320058","host_organization_name":"Association for the Advancement of Artificial Intelligence","host_organization_lineage":["https://openalex.org/P4310320058"],"host_organization_lineage_names":["Association for the Advancement of Artificial Intelligence"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the AAAI Conference on Artificial Intelligence","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1609/aaai.v39i22.34511","is_oa":true,"landing_page_url":"https://doi.org/10.1609/aaai.v39i22.34511","pdf_url":"https://ojs.aaai.org/index.php/AAAI/article/download/34511/36666","source":{"id":"https://openalex.org/S4210191458","display_name":"Proceedings of the AAAI Conference on Artificial Intelligence","issn_l":"2159-5399","issn":["2159-5399","2374-3468"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310320058","host_organization_name":"Association for the Advancement of Artificial Intelligence","host_organization_lineage":["https://openalex.org/P4310320058"],"host_organization_lineage_names":["Association for the Advancement of Artificial Intelligence"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the AAAI Conference on Artificial Intelligence","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4409362830.pdf","grobid_xml":"https://content.openalex.org/works/W4409362830.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2339422290","https://openalex.org/W2397653702","https://openalex.org/W3019157102","https://openalex.org/W4233871529","https://openalex.org/W2338818750","https://openalex.org/W2365451219","https://openalex.org/W2415869793","https://openalex.org/W4211072166","https://openalex.org/W28723353","https://openalex.org/W4231104876"],"abstract_inverted_index":{"Self-correction":[0],"in":[1,44,50,145,156],"text-to-SQL":[2],"is":[3],"the":[4,41,62,65,85,92,131,137,140,147,150],"process":[5],"of":[6,64,87,139,154],"prompting":[7],"large":[8],"language":[9],"model":[10],"(LLM)":[11],"to":[12,35,95,104],"revise":[13],"its":[14],"previously":[15],"incorrectly":[16],"generated":[17],"SQL,":[18],"and":[19,77,98,152],"commonly":[20],"relies":[21],"on":[22,84,91],"manually":[23],"crafted":[24],"self-correction":[25,66,101],"guidelines":[26],"by":[27,40,134],"human":[28,42,108,112],"experts":[29],"that":[30,60,118,130],"are":[31],"not":[32],"only":[33],"labor-intensive":[34],"produce":[36],"but":[37,110],"also":[38],"limited":[39],"ability":[43],"identifying":[45],"all":[46],"potential":[47],"error":[48],"patterns":[49],"LLM":[51,105],"responses.":[52],"We":[53,126],"introduce":[54],"MAGIC,":[55],"a":[56,73,75,78,100],"novel":[57],"multi-agent":[58],"method":[59,90],"automates":[61],"creation":[63],"guideline.":[67],"MAGIC":[68,135],"uses":[69],"three":[70],"specialized":[71],"agents:":[72],"manager,":[74],"correction,":[76],"feedback":[79],"agent.":[80],"These":[81],"agents":[82],"collaborate":[83],"failures":[86,151],"an":[88],"LLM-based":[89],"training":[93],"set":[94],"iteratively":[96],"generate":[97],"refine":[99],"guideline":[102,120,132],"tailored":[103],"mistakes,":[106],"mirroring":[107],"processes":[109],"without":[111],"involvement.":[113],"Our":[114],"extensive":[115],"experiments":[116],"show":[117],"MAGIC's":[119],"outperforms":[121],"expert":[122],"human's":[123],"created":[124],"ones.":[125],"empirically":[127],"find":[128],"out":[129],"produced":[133],"enhances":[136],"interpretability":[138],"corrections":[141],"made,":[142],"providing":[143],"insights":[144],"analyzing":[146],"reason":[148],"behind":[149],"successes":[153],"LLMs":[155],"self-correction.":[157]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":8}],"updated_date":"2026-03-27T14:29:43.386196","created_date":"2025-10-10T00:00:00"}