12 November 2026 16:00 - 16:30
Automating the creation of evals for an enterprise natural-language-to-SQL agent
Text-to-SQL looks solved on academic benchmarks, and enterprise data shows it isnāt.
Models that score above 90% on Spider 1.0 drop to about 21% on Spider 2.0, which uses real warehouse schemas that often have more than 1,000 columns. The benchmarks themselves are also unreliable.
One audit found that 21 of the 25 empty-result queries in Spiderās test set have wrong gold labels, and that around 15% of test questions depend on an ambiguous ātop-kā assumption.
So a hand-written golden set wonāt tell you whether your agent is right.
This session covers how to generate evals automatically for a NL2SQL agent running against a large production data platform:
ā Generating question and SQL pairs from your schema and query logs
ā Dealing with questions that have more than one correct SQL answer
ā Picking match criteria (execution results, row order, DISTINCT) that donāt hide errors or invent them
ā Keeping the eval set current as schemas and metric definitions change