{"id":"https://openalex.org/W7160426473","doi":"https://doi.org/10.48550/arxiv.2605.03720","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-05-05","ids":{"openalex":"https://openalex.org/W7160426473","doi":"https://doi.org/10.48550/arxiv.2605.03720"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2605.03720","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.03720","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2605.03720","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5135438498","display_name":"Le Zhou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhou, Le","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135443836","display_name":"Feng Yao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yao, Feng","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":"Qiao, Fengcai","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135528994","display_name":"Bo Xu","orcid":"https://orcid.org/0000-0001-6853-6969"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Bo","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135477745","display_name":"Fangyuan Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Fangyuan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5135482688","display_name":"Boyan Xu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Boyan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"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/T10028","display_name":"Topic Modeling","score":0.11259999871253967,"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.11259999871253967,"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.09650000184774399,"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/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.0828000009059906,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/inference","display_name":"Inference","score":0.5784000158309937},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.525600016117096},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4634000062942505},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4481000006198883},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4447999894618988},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.3637000024318695},{"id":"https://openalex.org/keywords/automated-reasoning","display_name":"Automated reasoning","score":0.35010001063346863}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8070999979972839},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.5784000158309937},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.525600016117096},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5142999887466431},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4634000062942505},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4481000006198883},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4447999894618988},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.3637000024318695},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.35519999265670776},{"id":"https://openalex.org/C195344581","wikidata":"https://www.wikidata.org/wiki/Q2555318","display_name":"Automated reasoning","level":2,"score":0.35010001063346863},{"id":"https://openalex.org/C161301231","wikidata":"https://www.wikidata.org/wiki/Q3478658","display_name":"Knowledge representation and reasoning","level":2,"score":0.3330000042915344},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32199999690055847},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.31709998846054077},{"id":"https://openalex.org/C59404180","wikidata":"https://www.wikidata.org/wiki/Q17013334","display_name":"Feature learning","level":2,"score":0.3077999949455261},{"id":"https://openalex.org/C43126263","wikidata":"https://www.wikidata.org/wiki/Q128751","display_name":"Source code","level":2,"score":0.2815000116825104},{"id":"https://openalex.org/C37335422","wikidata":"https://www.wikidata.org/wiki/Q6888134","display_name":"Model-based reasoning","level":3,"score":0.2782999873161316},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.27810001373291016},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.27639999985694885},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.2630999982357025},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2551000118255615},{"id":"https://openalex.org/C22367795","wikidata":"https://www.wikidata.org/wiki/Q7625208","display_name":"Structured prediction","level":2,"score":0.25029999017715454}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2605.03720","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.03720","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2605.03720","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.03720","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Recent":[0],"advances":[1],"in":[2,15,24],"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,84],"and":[18,82,129,147,156],"mathematical":[19],"reasoning.":[20],"However,":[21],"their":[22],"potential":[23],"multi-turn":[25],"Text-to-SQL":[26],"tasks":[27],"remains":[28],"largely":[29],"underexplored.":[30],"Existing":[31],"approaches":[32],"typically":[33],"rely":[34],"on":[35,43,126,163],"unstable":[36],"API-based":[37],"inference":[38],"or":[39],"require":[40],"expensive":[41],"fine-tuning":[42],"small-scale":[44,57],"models.":[45],"In":[46],"this":[47],"work,":[48],"we":[49],"present":[50],"Rose-SQL,":[51],"a":[52,71,88],"training-free":[53],"framework":[54],"that":[55,74],"leverages":[56],"LRMs":[58],"through":[59,101,121],"in-context":[60,140],"learning":[61,141],"to":[62,111],"enable":[63],"accurate":[64],"context-dependent":[65],"parsing.":[66],"We":[67],"introduce":[68],"the":[69,76,97,109,113,118,127,135,144,154],"Role-State,":[70],"fine-grained":[72],"representation":[73],"bridges":[75],"structural":[77,89,105],"gap":[78],"between":[79],"schema":[80],"linking":[81],"SQL":[83,115],"by":[85],"serving":[86],"as":[87],"blueprint.":[90],"To":[91],"handle":[92],"conversational":[93],"dependencies,":[94],"Rose-SQL":[95,138],"traces":[96],"evolution":[98],"of":[99],"Role-State":[100],"historical":[102],"context":[103],"via":[104],"isomorphism":[106],"checks,":[107],"guiding":[108],"model":[110],"infer":[112],"possible":[114],"composition":[116],"for":[117],"current":[119],"question":[120],"verified":[122],"interaction":[123],"trajectories.":[124],"Experiments":[125],"SParC":[128],"CoSQL":[130],"benchmarks":[131],"show":[132],"that,":[133],"within":[134],"Qwen3":[136],"series,":[137],"outperforms":[139],"baselines":[142],"at":[143,153],"4B":[145],"scale":[146],"substantially":[148],"surpasses":[149],"state-of-the-art":[150],"fine-tuned":[151],"models":[152],"8B":[155],"14B":[157],"scales,":[158],"while":[159],"showing":[160],"consistent":[161],"gains":[162],"additional":[164],"reasoning":[165],"backbones.":[166]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-07T00:00:00"}