{"id":"https://openalex.org/W7162457858","doi":"https://doi.org/10.1145/3788853.3801598","title":"CrackSQL: A Hybrid Dialect Translation System Powered by LLM","display_name":"CrackSQL: A Hybrid Dialect Translation System Powered by LLM","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7162457858","doi":"https://doi.org/10.1145/3788853.3801598"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3801598","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801598","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3788853.3801598","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5137047547","display_name":"Wei Zhou","orcid":"https://orcid.org/0009-0000-8862-7753"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Zhou","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0000-8862-7753","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136995554","display_name":"Yuyang Gao","orcid":"https://orcid.org/0009-0008-0773-1902"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuyang Gao","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0008-0773-1902","affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056912386","display_name":"Xuanhe Zhou","orcid":"https://orcid.org/0000-0002-2285-7836"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuanhe Zhou","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-2285-7836","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058334067","display_name":"G Li","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guoliang Li","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-1398-0621","affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.84718377,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"154","last_page":"157"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9192000031471252,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9192000031471252,"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/T12380","display_name":"Authorship Attribution and Profiling","score":0.0038999998942017555,"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/T12326","display_name":"Network Packet Processing and Optimization","score":0.0034000000450760126,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/translation","display_name":"Translation (biology)","score":0.3407999873161316},{"id":"https://openalex.org/keywords/machine-translation","display_name":"Machine translation","score":0.31029999256134033},{"id":"https://openalex.org/keywords/tracking-system","display_name":"Tracking system","score":0.26159998774528503},{"id":"https://openalex.org/keywords/speech-translation","display_name":"Speech translation","score":0.25600001215934753},{"id":"https://openalex.org/keywords/feature","display_name":"Feature (linguistics)","score":0.24549999833106995}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6176000237464905},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4507000148296356},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4255000054836273},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.4018000066280365},{"id":"https://openalex.org/C149364088","wikidata":"https://www.wikidata.org/wiki/Q185917","display_name":"Translation (biology)","level":4,"score":0.3407999873161316},{"id":"https://openalex.org/C203005215","wikidata":"https://www.wikidata.org/wiki/Q79798","display_name":"Machine translation","level":2,"score":0.31029999256134033},{"id":"https://openalex.org/C154586513","wikidata":"https://www.wikidata.org/wiki/Q4420972","display_name":"Tracking system","level":3,"score":0.26159998774528503},{"id":"https://openalex.org/C2780366754","wikidata":"https://www.wikidata.org/wiki/Q7494857","display_name":"Speech translation","level":3,"score":0.25600001215934753},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.24549999833106995},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.24420000612735748}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788853.3801598","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801598","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3788853.3801598","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801598","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W4396988324","https://openalex.org/W4411403466","https://openalex.org/W4414244643","https://openalex.org/W7161595599"],"related_works":[],"abstract_inverted_index":{"SQL":[0,74],"dialect":[1,75],"translation":[2,48,76,134,139,148,173],"is":[3,90,176],"critical":[4],"for":[5],"enabling":[6,165],"interoperability":[7],"across":[8],"different":[9],"database":[10],"systems.":[11],"However,":[12],"translating":[13],"queries":[14],"between":[15],"dialects":[16],"(e.g.,":[17,45,55],"PostgreSQL":[18],"to":[19,24,85,125,141],"MySQL)":[20],"remains":[21],"challenging":[22],"due":[23],"syntactic":[25],"discrepancies":[26],"and":[27,150,161,171,179],"subtle":[28],"semantic":[29,143],"mismatches.":[30],"Existing":[31],"approaches":[32],"(i.e.,":[33],"manual":[34],"translation,":[35],"rule-based":[36,80],"systems,":[37],"LLM-based":[38,83],"methods)":[39],"either":[40],"demand":[41],"substantial":[42],"engineering":[43],"effort":[44],"crafting":[46],"custom":[47],"rules)":[49],"or":[50],"suffer":[51],"from":[52],"reliability":[53],"issues":[54],"hallucinating":[56],"non-existent":[57],"functions),":[58],"especially":[59],"when":[60],"dealing":[61],"with":[62,82],"complex":[63,105],"queries.":[64],"In":[65],"this":[66],"demonstration,":[67],"we":[68],"present":[69],"CrackSQL,":[70],"the":[71],"first":[72],"hybrid":[73],"system":[77],"that":[78,102,120,136],"integrates":[79],"techniques":[81],"methods":[84],"overcome":[86],"these":[87],"limitations.":[88],"CrackSQL":[89,145,175],"built":[91],"on":[92],"three":[93,147],"key":[94],"innovations:":[95],"(1)":[96],"A":[97,115],"functionality-based":[98],"query":[99],"processing":[100],"module":[101],"decomposes":[103],"lengthy,":[104],"SQLs":[106],"into":[107],"manageable":[108],"functional":[109],"units,":[110],"reducing":[111],"hallucination":[112],"risk;":[113],"(2)":[114],"cross-dialect":[116],"syntax":[117,123,128],"embedding":[118],"model":[119],"aligns":[121],"textual":[122],"specifications":[124],"support":[126],"accurate":[127],"matching;":[129],"(3)":[130],"An":[131],"adaptive":[132],"local-to-global":[133],"strategy":[135],"incrementally":[137],"expands":[138],"scope":[140],"preserve":[142],"correctness.":[144],"supports":[146],"modes":[149],"offers":[151],"flexible":[152],"deployment":[153],"options":[154],"via":[155],"a":[156],"web":[157],"console,":[158],"PyPI":[159],"package,":[160],"command-line":[162],"interface,":[163],"thus":[164],"seamless":[166],"integration":[167],"in":[168],"both":[169],"interactive":[170],"batch":[172],"scenarios.":[174],"fully":[177],"implemented":[178],"available":[180],"at:":[181],"https://github.com/weAIDB/CrackSQL.":[182]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-27T00:00:00"}