Researchers introduced ESQ-Bench to address the gap between academic NL2SQL benchmarks and real-world enterprise complexity. The benchmark uses six populated schemas across Oracle, PostgreSQL, MySQL, and SQL Server to test dialect generalization and silent semantic divergence. It includes 550 gold-validated question-query pairs and a four-metric evaluation harness to measure execution accuracy beyond simple string matching.
- ESQ-Bench exposes silent semantic divergence where models succeed on simple metrics but fail on complex enterprise logic.
- Tested across Oracle, PostgreSQL, MySQL, and SQL Server to validate dialect generalization capabilities.
- Uses 465 tables with zero empty tables to simulate realistic enterprise schema density.
- Current SOTA models may overperform on Spider/BIRD; ESQ-Bench provides a stricter reality check.
- Evaluation harness tracks EM, EX, SR, and SD metrics for comprehensive model assessment.