{"id":"https://openalex.org/W7154451104","doi":"https://doi.org/10.48550/arxiv.2604.12988","title":"ROSE: An Intent-Centered Evaluation Metric for NL2SQL","display_name":"ROSE: An Intent-Centered Evaluation Metric for NL2SQL","publication_year":2026,"publication_date":"2026-04-14","ids":{"openalex":"https://openalex.org/W7154451104","doi":"https://doi.org/10.48550/arxiv.2604.12988"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2604.12988","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.12988","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":"Preprint"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2604.12988","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5133680071","display_name":"Wenqi Pei","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pei, Wenqi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133702784","display_name":"Shizheng Hou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hou, Shizheng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113242148","display_name":"Boyan Li","orcid":"https://orcid.org/0009-0001-4662-5124"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Boyan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100732646","display_name":"Han Chen","orcid":"https://orcid.org/0000-0002-8474-6867"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Han","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133693722","display_name":"Zhichao Shi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shi, Zhichao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5133725867","display_name":"Yuyu Luo","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Luo, Yuyu","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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.24199999868869781,"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"}},"topics":[{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.24199999868869781,"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"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.1996999979019165,"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"}},{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.0478999987244606,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7181000113487244},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.611299991607666},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.5954999923706055},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.5898000001907349},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.5569000244140625},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5271000266075134},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.45500001311302185}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7282999753952026},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7181000113487244},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.611299991607666},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.5954999923706055},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.5898000001907349},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5569000244140625},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5547999739646912},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5271000266075134},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.45500001311302185},{"id":"https://openalex.org/C37736160","wikidata":"https://www.wikidata.org/wiki/Q1801315","display_name":"Adversarial system","level":2,"score":0.3822000026702881},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.3804999887943268},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3476000130176544},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.31630000472068787},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3052000105381012},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.30390000343322754},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2962999939918518},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.27570000290870667},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.27250000834465027},{"id":"https://openalex.org/C98183937","wikidata":"https://www.wikidata.org/wiki/Q2112188","display_name":"Program analysis","level":2,"score":0.26809999346733093},{"id":"https://openalex.org/C193429382","wikidata":"https://www.wikidata.org/wiki/Q232405","display_name":"Metric system","level":2,"score":0.2531999945640564}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2604.12988","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.12988","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":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2604.12988","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.12988","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":"Preprint"},"sustainable_development_goals":[{"score":0.46792304515838623,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Execution":[0],"Accuracy":[1],"(EX),":[2],"the":[3,9,56,60,66,70,82,90,98,117,124],"widely":[4],"used":[5],"metric":[6,51,126],"for":[7],"evaluating":[8],"effectiveness":[10],"of":[11,85,139],"Natural":[12],"Language":[13],"to":[14,25,103,152],"SQL":[15,58,68,79,88,100],"(NL2SQL)":[16],"solutions,":[17],"is":[18,23,36],"becoming":[19],"increasingly":[20],"unreliable.":[21],"It":[22],"sensitive":[24],"syntactic":[26],"variation,":[27],"ignores":[28],"that":[29,52],"questions":[30],"may":[31],"admit":[32],"multiple":[33],"interpretations,":[34],"and":[35,105,150],"easily":[37],"misled":[38],"by":[39,127],"erroneous":[40],"ground-truth":[41,67,99],"SQL.":[42],"To":[43],"address":[44],"this,":[45],"we":[46],"introduce":[47],"ROSE,":[48],"an":[49,75],"intent-centered":[50],"focuses":[53],"on":[54],"whether":[55],"predicted":[57,87],"answers":[59],"question,":[61],"rather":[62],"than":[63],"consistency":[64],"with":[65,120],"under":[69],"reference-dependent":[71],"paradigm.":[72],"ROSE":[73,115,149],"employs":[74],"adversarial":[76],"Prover-Refuter":[77],"cascade:":[78],"Prover":[80],"assesses":[81],"semantic":[83],"correctness":[84],"a":[86,136],"against":[89],"user's":[91],"intent":[92],"independently,":[93],"while":[94],"Adversarial":[95],"Refuter":[96],"uses":[97],"as":[101],"evidence":[102],"challenge":[104],"refine":[106],"this":[107],"judgment.":[108],"On":[109],"our":[110],"expert-aligned":[111],"validation":[112],"set":[113],"ROSE-VEC,":[114],"achieves":[116],"best":[118],"agreement":[119],"human":[121],"experts,":[122],"outperforming":[123],"next-best":[125],"nearly":[128],"24%":[129],"in":[130],"Cohen's":[131],"Kappa.":[132],"We":[133,147],"also":[134],"conduct":[135],"largescale":[137],"re-evaluation":[138],"19":[140],"NL2SQL":[141,156],"methods,":[142],"revealing":[143],"four":[144],"valuable":[145],"insights.":[146],"release":[148],"ROSE-VEC":[151],"facilitate":[153],"more":[154],"reliable":[155],"research.":[157]},"counts_by_year":[],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-04-16T00:00:00"}