{"id":"https://openalex.org/W7160244468","doi":"https://doi.org/10.48550/arxiv.2605.02815","title":"FlexSQL: Flexible Exploration and Execution Make Better Text-to-SQL Agents","display_name":"FlexSQL: Flexible Exploration and Execution Make Better Text-to-SQL Agents","publication_year":2026,"publication_date":"2026-05-04","ids":{"openalex":"https://openalex.org/W7160244468","doi":"https://doi.org/10.48550/arxiv.2605.02815"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2605.02815","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.02815","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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.2605.02815","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5008421532","display_name":"Quang Hi\u1ebfu Ph\u1ea1m","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pham, Quang Hieu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135400376","display_name":"Yang He","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"He, Yang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135395790","display_name":"Ping Nie","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nie, Ping","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102941860","display_name":"Canwen Xu","orcid":"https://orcid.org/0000-0002-1552-999X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Canwen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071837282","display_name":"Davood Rafiei","orcid":"https://orcid.org/0000-0003-2403-0266"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rafiei, Davood","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135299556","display_name":"Yuepeng Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Yuepeng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100355602","display_name":"Xi Ye","orcid":"https://orcid.org/0000-0003-0331-7946"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ye, Xi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5134090098","display_name":"Jocelyn Qiaochu Chen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Jocelyn Qiaochu","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/T10317","display_name":"Advanced Database Systems and Queries","score":0.5692999958992004,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5692999958992004,"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/T10126","display_name":"Logic, programming, and type systems","score":0.07020000368356705,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.04740000143647194,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5067999958992004},{"id":"https://openalex.org/keywords/limiting","display_name":"Limiting","score":0.44909998774528503},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4438000023365021},{"id":"https://openalex.org/keywords/coding","display_name":"Coding (social sciences)","score":0.42559999227523804},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.38119998574256897},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.3702999949455261},{"id":"https://openalex.org/keywords/data-exploration","display_name":"Data exploration","score":0.35499998927116394},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.35100001096725464},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3109999895095825}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8269000053405762},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5067999958992004},{"id":"https://openalex.org/C188198153","wikidata":"https://www.wikidata.org/wiki/Q1613840","display_name":"Limiting","level":2,"score":0.44909998774528503},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4438000023365021},{"id":"https://openalex.org/C179518139","wikidata":"https://www.wikidata.org/wiki/Q5140297","display_name":"Coding (social sciences)","level":2,"score":0.42559999227523804},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4172999858856201},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3939000070095062},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.38119998574256897},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3788999915122986},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.3702999949455261},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.35499998927116394},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.35100001096725464},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.314300000667572},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3109999895095825},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3052999973297119},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.3050000071525574},{"id":"https://openalex.org/C2780598303","wikidata":"https://www.wikidata.org/wiki/Q65921492","display_name":"Flexibility (engineering)","level":2,"score":0.2915000021457672},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2897000014781952},{"id":"https://openalex.org/C174348530","wikidata":"https://www.wikidata.org/wiki/Q188635","display_name":"Bridging (networking)","level":2,"score":0.2872999906539917},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.2808000147342682},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2775999903678894},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.27230000495910645},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.2720000147819519},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.2632000148296356},{"id":"https://openalex.org/C129916263","wikidata":"https://www.wikidata.org/wiki/Q1141183","display_name":"Backward chaining","level":4,"score":0.26089999079704285},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.2606000006198883},{"id":"https://openalex.org/C71139939","wikidata":"https://www.wikidata.org/wiki/Q910194","display_name":"Modal","level":2,"score":0.25760000944137573},{"id":"https://openalex.org/C142614401","wikidata":"https://www.wikidata.org/wiki/Q777433","display_name":"Forward chaining","level":3,"score":0.25380000472068787},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.25110000371932983},{"id":"https://openalex.org/C147494362","wikidata":"https://www.wikidata.org/wiki/Q2078905","display_name":"Troubleshooting","level":2,"score":0.25110000371932983}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2605.02815","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.02815","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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.2605.02815","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.02815","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":[],"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],"over":[1,153],"large":[2],"analytical":[3],"databases":[4],"requires":[5],"navigating":[6],"complex":[7],"schemas,":[8],"resolving":[9],"ambiguous":[10],"queries,":[11],"and":[12,32,69,100,136,165],"grounding":[13],"decisions":[14],"in":[15,91,147],"actual":[16],"data.":[17],"Most":[18],"current":[19],"systems":[20],"follow":[21],"a":[22,49,102,121,141,179],"fixed":[23],"pipeline":[24],"where":[25],"schema":[26,64],"elements":[27],"are":[28],"retrieved":[29],"once":[30],"upfront":[31],"the":[33,60,98,171],"database":[34,58],"is":[35,56,185],"only":[36],"revisited":[37],"for":[38],"post-hoc":[39],"repair,":[40],"limiting":[41],"recovery":[42],"from":[43,109],"early":[44],"mistakes.":[45],"We":[46],"present":[47],"FlexSQL,":[48],"text-to-SQL":[50],"agent":[51,61,144],"whose":[52],"core":[53],"design":[54,181],"principle":[55],"flexible":[57,163,166],"interaction:":[59],"can":[62,107],"explore":[63],"structure,":[65],"inspect":[66],"data":[67],"values,":[68],"run":[70],"verification":[71],"queries":[72],"at":[73],"any":[74],"point":[75],"during":[76],"reasoning.":[77],"FlexSQL":[78,119],"generates":[79],"diverse":[80],"execution":[81,167],"plans":[82],"to":[83,112,170],"cover":[84],"multiple":[85],"query":[86],"interpretations,":[87],"implements":[88],"each":[89],"plan":[90],"either":[92],"SQL":[93],"or":[94],"Python":[95],"depending":[96],"on":[97,157],"task,":[99],"uses":[101],"two-tiered":[103],"repair":[104],"mechanism":[105],"that":[106,128,162],"backtrack":[108],"code-level":[110],"errors":[111],"plan-level":[113],"revisions.":[114],"On":[115],"Spider2-Snow,":[116],"using":[117],"gpt-oss-120b,":[118],"achieves":[120],"65.4\\%":[122],"score,":[123],"outperforming":[124],"strong":[125],"open-source":[126],"baselines":[127],"use":[129],"stronger,":[130],"larger":[131],"models":[132],"such":[133],"as":[134,178],"gpt-o3":[135],"DeepSeek-R1.":[137],"When":[138],"integrated":[139],"into":[140],"general-purpose":[142],"coding":[143],"(as":[145],"skills":[146],"Claude":[148],"Code),":[149],"our":[150,174],"approach":[151],"yields":[152],"10\\%":[154],"relative":[155],"improvement":[156],"Spider2-Snow.":[158],"Further":[159],"analysis":[160],"shows":[161],"exploration":[164],"jointly":[168],"contribute":[169],"effectiveness":[172],"of":[173],"approach,":[175],"highlighting":[176],"flexibility":[177],"key":[180],"principle.":[182],"Our":[183],"code":[184],"available":[186],"at:":[187],"https://github.com/StringNLPLAB/FlexSQL":[188]},"counts_by_year":[],"updated_date":"2026-07-28T07:46:37.118299","created_date":"2026-05-06T00:00:00"}