Vadim's blog

What is a self-healing loop in NL-to-SQL?

It is an automated feedback loop. A failed query's database error becomes the repair signal. The model diagnoses that error and regenerates a corrected query, bounded here to two attempts.

Does Cloudflare D1 support the SQL that CRM analytics needs?

D1 uses SQLite semantics. It supports joins, aggregations, and subqueries — enough for the funnel and attribution queries here. The graph emits SQLite-only syntax, never PostgreSQL casts or ILIKE.

How does the system prevent a destructive query?

A two-layer SELECT-only gate. The query must start with SELECT or WITH, and a statement-boundary regex blocks every write or DDL keyword. Repaired queries re-enter the same gate, so a repair can never widen permissions.

Can the same pattern run on Postgres or MySQL?

The gate and repair loop generalize, but the SQL dialect and the D1 transport (infra.db.d1_all) are D1-specific. The self-healing pattern itself is database-agnostic.