{"id":"https://openalex.org/W7164909132","doi":"https://doi.org/10.48550/arxiv.2606.15598","title":"Integrating Reasoning and Generalization in Text-to-SQL via Self-Enhanced Fine-Tuning","display_name":"Integrating Reasoning and Generalization in Text-to-SQL via Self-Enhanced Fine-Tuning","publication_year":2026,"publication_date":"2026-06-14","ids":{"openalex":"https://openalex.org/W7164909132","doi":"https://doi.org/10.48550/arxiv.2606.15598"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2606.15598","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.15598","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"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"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2606.15598","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035157184","display_name":"Feng Lyu","orcid":"https://orcid.org/0000-0002-2990-5415"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lyu, Feng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038938707","display_name":"Jinfeng Cen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Cen, Jinfeng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031745233","display_name":"Sijing Duan","orcid":"https://orcid.org/0000-0003-3295-8822"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Duan, Sijing","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113485823","display_name":"H. Wu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wu, Hao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026231038","display_name":"Shucheng Li","orcid":"https://orcid.org/0000-0002-5414-6203"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Shucheng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5138731520","display_name":"Weixu Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Weixu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5113485823","display_name":"H. Wu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wu, Haolun","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.4611999988555908,"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.4611999988555908,"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/T10028","display_name":"Topic Modeling","score":0.23309999704360962,"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/T14347","display_name":"Big Data and Digital Economy","score":0.02160000056028366,"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/executable","display_name":"Executable","score":0.6793000102043152},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5911999940872192},{"id":"https://openalex.org/keywords/generalization","display_name":"Generalization","score":0.5483999848365784},{"id":"https://openalex.org/keywords/modular-design","display_name":"Modular design","score":0.4999000132083893},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.46459999680519104},{"id":"https://openalex.org/keywords/decomposition","display_name":"Decomposition","score":0.4350999891757965},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.39399999380111694},{"id":"https://openalex.org/keywords/visual-reasoning","display_name":"Visual reasoning","score":0.36660000681877136}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7343999743461609},{"id":"https://openalex.org/C160145156","wikidata":"https://www.wikidata.org/wiki/Q778586","display_name":"Executable","level":2,"score":0.6793000102043152},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5911999940872192},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5551000237464905},{"id":"https://openalex.org/C177148314","wikidata":"https://www.wikidata.org/wiki/Q170084","display_name":"Generalization","level":2,"score":0.5483999848365784},{"id":"https://openalex.org/C101468663","wikidata":"https://www.wikidata.org/wiki/Q1620158","display_name":"Modular design","level":2,"score":0.4999000132083893},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.46459999680519104},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.44620001316070557},{"id":"https://openalex.org/C124681953","wikidata":"https://www.wikidata.org/wiki/Q339062","display_name":"Decomposition","level":2,"score":0.4350999891757965},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.39399999380111694},{"id":"https://openalex.org/C2777508537","wikidata":"https://www.wikidata.org/wiki/Q7936620","display_name":"Visual reasoning","level":2,"score":0.36660000681877136},{"id":"https://openalex.org/C195344581","wikidata":"https://www.wikidata.org/wiki/Q2555318","display_name":"Automated reasoning","level":2,"score":0.3540000021457672},{"id":"https://openalex.org/C112313634","wikidata":"https://www.wikidata.org/wiki/Q7886648","display_name":"Complement (music)","level":5,"score":0.3474999964237213},{"id":"https://openalex.org/C2776187449","wikidata":"https://www.wikidata.org/wiki/Q1513879","display_name":"Natural language generation","level":3,"score":0.310699999332428},{"id":"https://openalex.org/C2776608160","wikidata":"https://www.wikidata.org/wiki/Q4785462","display_name":"Natural (archaeology)","level":2,"score":0.29679998755455017},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.2930000126361847},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2915000021457672},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.287200003862381},{"id":"https://openalex.org/C89288958","wikidata":"https://www.wikidata.org/wiki/Q7301504","display_name":"Reasoning system","level":2,"score":0.2865000069141388},{"id":"https://openalex.org/C2779913896","wikidata":"https://www.wikidata.org/wiki/Q7063001","display_name":"Notice","level":2,"score":0.2669999897480011},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2637999951839447},{"id":"https://openalex.org/C161301231","wikidata":"https://www.wikidata.org/wiki/Q3478658","display_name":"Knowledge representation and reasoning","level":2,"score":0.2533999979496002}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2606.15598","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.15598","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"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":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2606.15598","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.15598","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"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"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Text-to-SQL":[0],"aims":[1],"to":[2,17,40,58],"translate":[3],"natural":[4],"language":[5,26],"questions":[6],"into":[7],"executable":[8],"SQL":[9,95],"queries":[10],"over":[11],"structured":[12,79,154],"databases,":[13],"enabling":[14],"non-expert":[15],"users":[16],"access":[18],"data":[19],"intuitively.":[20],"While":[21],"recent":[22],"advances":[23],"in":[24,32],"large":[25],"models":[27],"(LLMs)":[28],"have":[29],"shown":[30],"promise":[31],"this":[33],"task,":[34],"existing":[35],"LLM-based":[36,61,161],"approaches":[37],"often":[38],"struggle":[39],"strike":[41],"a":[42],"balance":[43],"between":[44],"strong":[45,131],"reasoning":[46,70],"capabilities":[47],"and":[48,86,89,103,130,156],"robust":[49],"generalization.":[50],"To":[51],"address":[52],"these":[53],"limitations,":[54],"we":[55],"propose":[56],"CoTE-SQL":[57,108],"enhance":[59],"the":[60,101,149],"text-to-SQL":[62,164],"generation":[63],"with":[64,83,119,140],"three":[65],"key":[66],"innovations:":[67],"(i)":[68],"self-enhanced":[69],"traces":[71],"distilled":[72],"from":[73],"LLMs":[74,118],"without":[75],"human":[76],"annotation,":[77],"(ii)":[78],"chain-of-thought":[80],"(CoT)":[81],"prompting":[82],"modular":[84],"decomposition":[85],"examples":[87],"retrieval,":[88],"(iii)":[90],"error-aware":[91],"revision":[92],"based":[93],"on":[94,100,116,123,133,144],"execution":[96],"feedback.":[97],"Extensive":[98],"experiments":[99],"Spider":[102,134],"Bird":[104,124],"benchmarks":[105],"demonstrate":[106],"that":[107],"achieves":[109],"new":[110],"state-of-the-art":[111],"performance":[112],"among":[113],"methods":[114],"built":[115],"open-source":[117],"comparable":[120],"model":[121],"sizes":[122],"(53.39%":[125],"EX":[126,136],"/":[127,137],"59.02":[128],"VES)":[129],"results":[132],"(79.60%":[135],"77.19":[138],"VES),":[139],"especially":[141],"significant":[142],"gains":[143],"complex":[145],"queries.":[146],"Results":[147],"highlight":[148],"effectiveness":[150],"of":[151],"combining":[152],"self-enhancement,":[153],"reasoning,":[155],"execution-time":[157],"feedback":[158],"within":[159],"an":[160],"framework":[162],"for":[163],"design.":[165]},"counts_by_year":[],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-06-17T00:00:00"}