{"id":"https://openalex.org/W7161990879","doi":"https://doi.org/10.48550/arxiv.2605.21027","title":"Beyond Text-to-SQL: An Agentic LLM System for Governed Enterprise Analytics APIs","display_name":"Beyond Text-to-SQL: An Agentic LLM System for Governed Enterprise Analytics APIs","publication_year":2026,"publication_date":"2026-05-20","ids":{"openalex":"https://openalex.org/W7161990879","doi":"https://doi.org/10.48550/arxiv.2605.21027"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2605.21027","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.21027","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":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.2605.21027","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5136670443","display_name":"Gundeep Singh","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Singh, Gundeep","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136640300","display_name":"Parsa Kavehzadeh","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kavehzadeh, Parsa","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136636924","display_name":"Jing Xia","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xia, Jing","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082860480","display_name":"Xue-Yong Fu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Fu, Xue-Yong","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029981243","display_name":"Julien Tremblay","orcid":"https://orcid.org/0000-0002-6085-3481"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tremblay, Julien Bouvier","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069546450","display_name":"Md Tahmid Rahman Laskar","orcid":"https://orcid.org/0009-0001-7880-299X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Laskar, Md Tahmid Rahman","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136662609","display_name":"Vincent Lum","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lum, Vincent","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5074485525","display_name":"Shashi Bhushan TN","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"TN, Shashi Bhushan","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/T11891","display_name":"Big Data and Business Intelligence","score":0.2694000005722046,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.2694000005722046,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.1264999955892563,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.034299999475479126,"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/analytics","display_name":"Analytics","score":0.6323999762535095},{"id":"https://openalex.org/keywords/enterprise-systems-engineering","display_name":"Enterprise systems engineering","score":0.5328999757766724},{"id":"https://openalex.org/keywords/enterprise-system","display_name":"Enterprise system","score":0.504800021648407},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.48899999260902405},{"id":"https://openalex.org/keywords/enterprise-software","display_name":"Enterprise software","score":0.4837000072002411},{"id":"https://openalex.org/keywords/enterprise-information-system","display_name":"Enterprise information system","score":0.4823000133037567},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.46720001101493835},{"id":"https://openalex.org/keywords/business-analytics","display_name":"Business analytics","score":0.4334999918937683},{"id":"https://openalex.org/keywords/business-rule","display_name":"Business rule","score":0.4235000014305115},{"id":"https://openalex.org/keywords/enterprise-integration","display_name":"Enterprise integration","score":0.40790000557899475}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7398999929428101},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6323999762535095},{"id":"https://openalex.org/C146342590","wikidata":"https://www.wikidata.org/wiki/Q11606385","display_name":"Enterprise systems engineering","level":4,"score":0.5328999757766724},{"id":"https://openalex.org/C67571701","wikidata":"https://www.wikidata.org/wiki/Q1318054","display_name":"Enterprise system","level":2,"score":0.504800021648407},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.48899999260902405},{"id":"https://openalex.org/C185765463","wikidata":"https://www.wikidata.org/wiki/Q1318054","display_name":"Enterprise software","level":2,"score":0.4837000072002411},{"id":"https://openalex.org/C27295321","wikidata":"https://www.wikidata.org/wiki/Q831795","display_name":"Enterprise information system","level":2,"score":0.4823000133037567},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.4810999929904938},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.47760000824928284},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.46720001101493835},{"id":"https://openalex.org/C37952496","wikidata":"https://www.wikidata.org/wiki/Q5001829","display_name":"Business analytics","level":4,"score":0.4334999918937683},{"id":"https://openalex.org/C11066294","wikidata":"https://www.wikidata.org/wiki/Q1518244","display_name":"Business rule","level":4,"score":0.4235000014305115},{"id":"https://openalex.org/C53996427","wikidata":"https://www.wikidata.org/wiki/Q5380387","display_name":"Enterprise integration","level":3,"score":0.40790000557899475},{"id":"https://openalex.org/C10590034","wikidata":"https://www.wikidata.org/wiki/Q1048431","display_name":"Enterprise architecture","level":3,"score":0.3968999981880188},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.3781000077724457},{"id":"https://openalex.org/C138824270","wikidata":"https://www.wikidata.org/wiki/Q3318162","display_name":"Enterprise modelling","level":4,"score":0.3718000054359436},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.3521000146865845},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.34380000829696655},{"id":"https://openalex.org/C184062371","wikidata":"https://www.wikidata.org/wiki/Q5380399","display_name":"Enterprise planning system","level":2,"score":0.3319999873638153},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3312000036239624},{"id":"https://openalex.org/C193669473","wikidata":"https://www.wikidata.org/wiki/Q5001867","display_name":"Business domain","level":5,"score":0.32120001316070557},{"id":"https://openalex.org/C2779439875","wikidata":"https://www.wikidata.org/wiki/Q1078276","display_name":"Natural language understanding","level":3,"score":0.31310001015663147},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3070000112056732},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.2955000102519989},{"id":"https://openalex.org/C136227091","wikidata":"https://www.wikidata.org/wiki/Q5380376","display_name":"Enterprise data management","level":3,"score":0.2888999879360199},{"id":"https://openalex.org/C545860419","wikidata":"https://www.wikidata.org/wiki/Q5193251","display_name":"Cultural analytics","level":5,"score":0.2865000069141388},{"id":"https://openalex.org/C82419060","wikidata":"https://www.wikidata.org/wiki/Q5380394","display_name":"Enterprise life cycle","level":2,"score":0.2797999978065491},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.2791999876499176},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.2745000123977661},{"id":"https://openalex.org/C161301231","wikidata":"https://www.wikidata.org/wiki/Q3478658","display_name":"Knowledge representation and reasoning","level":2,"score":0.2696000039577484},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.2696000039577484},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.26919999718666077},{"id":"https://openalex.org/C517642484","wikidata":"https://www.wikidata.org/wiki/Q2388514","display_name":"Intelligence analysis","level":2,"score":0.258899986743927},{"id":"https://openalex.org/C179603123","wikidata":"https://www.wikidata.org/wiki/Q1941921","display_name":"Modeling language","level":3,"score":0.2578999996185303},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.25589999556541443},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.2540000081062317},{"id":"https://openalex.org/C2779304628","wikidata":"https://www.wikidata.org/wiki/Q3503480","display_name":"Face (sociological concept)","level":2,"score":0.25290000438690186},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.2515000104904175}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2605.21027","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.21027","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":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.2605.21027","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.21027","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":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.7722234129905701,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Enterprise":[0],"analytics":[1,49,108],"aims":[2],"to":[3,39,67,79],"make":[4],"organizational":[5],"data":[6],"accessible":[7],"for":[8],"decision-making,":[9],"yet":[10],"non-technical":[11],"users":[12],"still":[13],"face":[14],"barriers":[15],"when":[16],"using":[17],"traditional":[18],"business":[19,65],"intelligence":[20],"tools":[21],"or":[22,76],"Text-to-SQL":[23,27],"systems.":[24],"While":[25],"recent":[26],"approaches":[28],"based":[29],"on":[30,52,111],"Large":[31],"Language":[32],"Models":[33],"(LLMs)":[34],"promise":[35],"natural":[36,100],"language":[37,101],"access":[38],"structured":[40],"data,":[41],"they":[42],"fall":[43],"short":[44],"in":[45],"enterprise":[46,107,114],"settings":[47],"where":[48],"pipelines":[50],"rely":[51],"governed":[53,129],"APIs":[54,62],"rather":[55],"than":[56],"raw":[57],"databases.":[58],"In":[59],"practice,":[60],"these":[61],"encapsulate":[63],"complex":[64],"logic":[66,78],"ensure":[68],"consistency,":[69],"auditability,":[70],"and":[71,84,131,138],"security.":[72],"However,":[73],"delegating":[74],"mathematical":[75],"aggregation":[77],"an":[80,94],"LLM":[81],"introduces":[82],"reliability":[83],"compliance":[85],"risks.":[86],"To":[87],"this":[88],"end,":[89],"we":[90],"present":[91],"Analytic":[92],"Agent,":[93],"LLM-based":[95],"agentic":[96],"system":[97],"that":[98],"translates":[99],"intents":[102],"into":[103],"secure":[104],"interactions":[105],"with":[106],"APIs.":[109],"Evaluated":[110],"90":[112],"real":[113],"use":[115],"cases":[116],"constructed":[117],"by":[118],"domain":[119],"experts,":[120],"it":[121],"reliably":[122],"interprets":[123],"user":[124],"goals,":[125],"validates":[126],"permissions,":[127],"executes":[128],"queries,":[130],"generates":[132],"compliant":[133],"visualizations":[134],"through":[135],"multi-step":[136],"reasoning":[137],"policy-aware":[139],"orchestration.":[140]},"counts_by_year":[],"updated_date":"2026-07-28T07:46:37.118299","created_date":"2026-05-22T00:00:00"}