0sql
A semantic layer product positioned between AI agents and data warehouses, compiling structured JSON specifications into governed deterministic SQL statements, with support for three tiers of security boundaries.
Timeline (last 90 days)
0sql positions itself as a semantic layer, sitting between the Agent and the data warehouse, translating business term specifications into governed SQL statements.
0sql expects structured JSON input, referencing fields, filters, and aggregations by semantic names, and does not parse natural language directly.
The 0sql engine guarantees that the same specification always produces the same SQL statement.
0sql's security model is divided into three layers: model-level governance, parameterized output, and row-level security.
0sql's semantic model is a business semantic contract described in YAML or JSON, usually stored under version control in a Git repository.
In the 0sql example, planning for the three-field query took 70 microseconds.
0sql ships with a CLI (zsql) that wraps the HTTP API and is designed for coding Agents capable of executing shell commands.
The 0sql engine is stateless, reads the semantic model from a Git branch (stored in 0sql cloud), and plans queries on demand.
0sql, compared with Cube and MetricFlow, has stronger expressiveness because it does not constrain the query shape.
The 0sql documentation explicitly lists several failure modes, including model drift and field name ambiguity.
2 more timeline events
All Facts (12)
0sql positions itself as a semantic layer, sitting between the Agent and the data warehouse, translating business term specifications into governed SQL statements.
50%Unverified0sql expects structured JSON input, referencing fields, filters, and aggregations by semantic names, and does not parse natural language directly.
50%UnverifiedThe 0sql engine guarantees that the same specification always produces the same SQL statement.
50%Unverified0sql's security model is divided into three layers: model-level governance, parameterized output, and row-level security.
50%Unverified0sql's semantic model is a business semantic contract described in YAML or JSON, usually stored under version control in a Git repository.
50%UnverifiedIn the 0sql example, planning for the three-field query took 70 microseconds.
50%Unverified0sql ships with a CLI (zsql) that wraps the HTTP API and is designed for coding Agents capable of executing shell commands.
50%UnverifiedThe 0sql engine is stateless, reads the semantic model from a Git branch (stored in 0sql cloud), and plans queries on demand.
50%Unverified0sql, compared with Cube and MetricFlow, has stronger expressiveness because it does not constrain the query shape.
50%UnverifiedThe 0sql documentation explicitly lists several failure modes, including model drift and field name ambiguity.
50%Unverified0sql's semantic model defines four types of elements: measures, dimensions, join relationships, and row-level security filters.
50%UnverifiedThe 0sql engine only compiles SQL and does not execute queries; the Agent is responsible for running the SQL on the data warehouse.
50%