arXiv:2610.33946v1 Announce Type: new Abstract: Text-to-SQL systems achieve remarkable accuracy on academic benchmarks, yet performance drops dramatically in enterprise deployments. This gap stems from a fundamental assumption: existing approaches require complete schema documentation, but enterprise databases typically lack comprehensive documentation, featuring cryptic naming and implicit relationships. We present the first text-to-SQL framework that operates without schema documentation, instead learning database structure from historical query logs. Query logs encode implicit structural knowledge: which tables are queried together, how they join, and what columns map to business concepts. We construct a knowledge graph from parsed query patterns and introduce entity-driven GraphRAG retrieval that grounds user questions in domain terminology rather than relying solely on embedding similarity. Validated on both an industrial deployment with expert evaluation and the Beaver benchmark, our approach substantially outperforms similarity-based retrieval methods, the dominant industry approach, in both executability and answer quality. On Beaver, we achieve 95.7% execution validity compared to 60.8% for embedding-based retrieval, with expert data engineers preferring our system 70% to 10% on internal deployment. Our work demonstrates that text-to-SQL can operate effectively in schema-ambiguous enterprise environments, enabling natural language database interfaces "in the wild".
Schema-Free Text-to-SQL: Learning Enterprise Database Structure from Query Logs
A new text-to-SQL framework that learns enterprise database structure from historical query logs rather than schema documentation achieved 95.7% execution validity on the Beaver benchmark, compared with 60.8% for embedding-based retrieval, according to an arXiv paper (2610.33946v1). The approach builds a knowledge graph from parsed query patterns and uses entity-driven GraphRAG retrieval to ground user questions in domain terminology, and on an industrial deployment expert data engineers preferred the system 70% to 10% over the incumbent method. The authors frame the work as the first text-to-SQL framework to operate without schema documentation, targeting enterprise databases with cryptic naming and implicit relationships.
Run your AI side-project on zahid.host
EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.