It Ran Is Not It Was Right: A Policy-Conditioned Benchmark of Ten Text-to-SQL Architectures on an Enterprise Database

Enterprise text-to-SQL assistants are usually judged by whether the SQL runs. On a realistic company database that is misleading: a query can run and still be wrong, return rows the asker may not see, ignore a rule in a policy document, or answer a question that should be refused. We build a testbed (59-table oil-and-gas database with role-based access, an approval workflow, nine policy documents) and a gold set of 94 questions labelled with the correct answer, the asking role, and whether to answer or refuse. Scoring ten published architectures on answer correctness, data leakage, policy grounding, and refusal overturns the execution-success ranking: the declared winner is ninth of ten on correctness, every architecture leaks restricted data (37 to 52 percent), almost none refuse, and the best is right about half the time. Results are stable over three runs, and the winner's validator gate does not fix any of these failures. Data is synthetic. We release the testbed, gold set, and scorer.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-09-04
DOI
https://doi.org/10.5281/zenodo.22307936
Primary Topic
Software System Performance and Reliability
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
preprint

It Ran Is Not It Was Right: A Policy-Conditioned Benchmark of Ten Text-to-SQL Architectures on an Enterprise Database

Yagya Raj Sharma
Zenodo (CERN European Organization for Nuclear Research)
Software System Performance and Reliability
preprint

It Ran Is Not It Was Right: A Policy-Conditioned Benchmark of Ten Text-to-SQL Architectures on an Enterprise Database

Yagya Raj Sharma
preprint en

Abstract

Enterprise text-to-SQL assistants are usually judged by whether the SQL runs. On a realistic company database that is misleading: a query can run and still be wrong, return rows the asker may not see, ignore a rule in a policy document, or answer a question that should be refused. We build a testbed (59-table oil-and-gas database with role-based access, an approval workflow, nine policy documents) and a gold set of 94 questions labelled with the correct answer, the asking role, and whether to answer or refuse. Scoring ten published architectures on answer correctness, data leakage, policy grounding, and refusal overturns the execution-success ranking: the declared winner is ninth of ten on correctness, every architecture leaks restricted data (37 to 52 percent), almost none refuse, and the best is right about half the time. Results are stable over three runs, and the winner's validator gate does not fix any of these failures. Data is synthetic. We release the testbed, gold set, and scorer.

Zenodo (CERN European Organization for Nuclear Research)
Peace, Justice and strong institutions
Software System Performance and Reliability
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.