{"id":"https://openalex.org/W7166865640","doi":"https://doi.org/10.18653/v1/2026.acl-long.2107","title":"Rose-SQL: Role-State Evolution Guided Structured Reasoning for Multi-Turn Text-to-SQL","display_name":"Rose-SQL: Role-State Evolution Guided Structured Reasoning for Multi-Turn Text-to-SQL","publication_year":2026,"publication_date":"2026-01-01","ids":{"openalex":"https://openalex.org/W7166865640","doi":"https://doi.org/10.18653/v1/2026.acl-long.2107"},"language":null,"primary_location":{"id":"doi:10.18653/v1/2026.acl-long.2107","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2026.acl-long.2107","pdf_url":"https://aclanthology.org/2026.acl-long.2107.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 64th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://aclanthology.org/2026.acl-long.2107.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5128639071","display_name":"Le Zhou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Le Zhou","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5139775260","display_name":"Feng Yao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Feng Yao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079637874","display_name":"Fengcai Qiao","orcid":"https://orcid.org/0000-0003-2947-3074"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fengcai Qiao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5139831595","display_name":"Bo Xu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bo Xu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5139846827","display_name":"Fangyuan Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fangyuan Wang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5034536387","display_name":"Boyan Xu","orcid":"https://orcid.org/0000-0003-1327-4740"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Boyan Xu","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":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.85463879,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"45442","last_page":"45459"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.08399999886751175,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.08399999886751175,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.08240000158548355,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.06530000269412994,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/process","display_name":"Process (computing)","score":0.3562000095844269},{"id":"https://openalex.org/keywords/structured-prediction","display_name":"Structured prediction","score":0.26649999618530273},{"id":"https://openalex.org/keywords/case-based-reasoning","display_name":"Case-based reasoning","score":0.2644999921321869},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.25440001487731934},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.2443999946117401}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5752999782562256},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4551999866962433},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.3562000095844269},{"id":"https://openalex.org/C22367795","wikidata":"https://www.wikidata.org/wiki/Q7625208","display_name":"Structured prediction","level":2,"score":0.26649999618530273},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.26570001244544983},{"id":"https://openalex.org/C20162079","wikidata":"https://www.wikidata.org/wiki/Q1151406","display_name":"Case-based reasoning","level":2,"score":0.2644999921321869},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.25440001487731934},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.2443999946117401},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.2401999980211258},{"id":"https://openalex.org/C195344581","wikidata":"https://www.wikidata.org/wiki/Q2555318","display_name":"Automated reasoning","level":2,"score":0.23880000412464142}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/2026.acl-long.2107","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2026.acl-long.2107","pdf_url":"https://aclanthology.org/2026.acl-long.2107.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 64th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/2026.acl-long.2107","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2026.acl-long.2107","pdf_url":"https://aclanthology.org/2026.acl-long.2107.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 64th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers)","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G167464954","display_name":null,"funder_award_id":"U24A20233","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3060735356","display_name":null,"funder_award_id":"2021ZD0111502","funder_id":"https://openalex.org/F4320329860","funder_display_name":"National Science and Technology Major Project"},{"id":"https://openalex.org/G4662166426","display_name":null,"funder_award_id":"62406078","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G6693685464","display_name":null,"funder_award_id":"2021ZD0111502","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320316125","display_name":"China Railway","ror":"https://ror.org/044wv3489"},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320329860","display_name":"National Science and Technology Major Project","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7166865640.pdf","grobid_xml":"https://content.openalex.org/works/W7166865640.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Recent":[0],"advances":[1],"in":[2,15,23],"Large":[3],"Reasoning":[4],"Models":[5],"(LRMs)":[6],"trained":[7],"with":[8],"Long":[9],"Chain-of-Thought":[10],"have":[11],"demonstrated":[12],"remarkable":[13],"capabilities":[14],"code":[16],"generation":[17,80],"and":[18,78,123,141,150],"mathematical":[19],"reasoning.However,":[20],"their":[21],"potential":[22],"multi-turn":[24],"Textto-SQL":[25],"tasks":[26],"remains":[27],"largely":[28],"underexplored.Existing":[29],"approaches":[30],"typically":[31],"rely":[32],"on":[33,41,120,157],"unstable":[34],"API-based":[35],"inference":[36],"or":[37],"require":[38],"expensive":[39],"fine-tuning":[40],"small-scale":[42,54],"models.In":[43],"this":[44],"work,":[45],"we":[46],"present":[47],"Rose-SQL,":[48],"a":[49,67,84],"training-free":[50],"framework":[51],"that":[52,70],"leverages":[53],"LRMs":[55],"through":[56,96,116],"in-context":[57,134],"learning":[58,135],"to":[59,106],"enable":[60],"accurate":[61],"context-dependent":[62],"parsing.We":[63],"introduce":[64],"the":[65,72,92,104,108,113,121,129,138,148],"Role-State,":[66],"fine-grained":[68],"representation":[69],"bridges":[71],"structural":[73,85,100],"gap":[74],"between":[75],"schema":[76],"linking":[77],"SQL":[79,110],"by":[81],"serving":[82],"as":[83],"blueprint.To":[86],"handle":[87],"conversational":[88],"dependencies,":[89],"Rose-SQL":[90,132],"traces":[91],"evolution":[93],"of":[94],"Role-State":[95],"historical":[97],"context":[98],"via":[99],"isomorphism":[101],"checks,":[102],"guiding":[103],"model":[105],"infer":[107],"possible":[109],"composition":[111],"for":[112],"current":[114],"question":[115],"verified":[117],"interaction":[118],"trajectories.Experiments":[119],"SParC":[122],"CoSQL":[124],"benchmarks":[125],"show":[126],"that,":[127],"within":[128],"Qwen3":[130],"series,":[131],"outperforms":[133],"baselines":[136],"at":[137,147],"4B":[139],"scale":[140],"substantially":[142],"surpasses":[143],"state-of-the-art":[144],"fine-tuned":[145],"models":[146],"8B":[149],"14B":[151],"scales,":[152],"while":[153],"showing":[154],"consistent":[155],"gains":[156],"additional":[158],"reasoning":[159],"backbones.":[160]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2026-07-02T00:00:00"}
