Tagged articles

SQL Security

2 articles · Page 1 of 1

Oct 13, 2026 · Backend Development

Production-Ready Text-to-SQL: Secure Governance from Restricted Semantics to Revocable Execution

This article details a comprehensive governance framework for deploying Text-to-SQL systems in production, covering threat modeling, AST validation, multi-tenant isolation, performance admission via EXPLAIN, database permission hardening, budget-aware execution, cancellation semantics, and phased rollout strategies to ensure secure, auditable, and revocable data access.

AST ValidationEXPLAIN PlanJSqlParser

0 likes · 39 min read

Production-Ready Text-to-SQL: Secure Governance from Restricted Semantics to Revocable Execution

Ray's Galactic Tech

Oct 11, 2026 · Backend Development

Building Production-Grade Text-to-SQL: From Natural Language to Trustworthy Data Analysis

The article presents a complete engineering framework for production Text-to-SQL systems, covering semantic contracts, metadata retrieval, controlled query compilation, security enforcement, execution budgets, evaluation, and phased rollout, using a "East China weekly payment GMV YoY" case study to demonstrate how to deliver trustworthy, auditable analytical answers rather than just executable SQL.

Execution BudgetMetadata RetrievalProduction Engineering

0 likes · 45 min read

Building Production-Grade Text-to-SQL: From Natural Language to Trustworthy Data Analysis