The Compiler for
Time-Correct Data
SqlCAD is a compiler that guarantees Point-in-Time correctness. Define your model as a graph, and let the compiler generate the complex, leak-proof SQL required for historical accuracy.
Why SqlCAD?
Built for correctness, designed for engineering.
Time-Travel Correctness
Prevent data leakage by default. SqlCAD automates SCD Type 2 tracking and generates point-in-time correct joins, ensuring your reports always reflect reality as it was.
Graph-First Architecture
Define relationships once, use them everywhere. The compiler understands your graph and automatically generates complex join paths, eliminating fragile boilerplate.
Strongly Typed
Catch errors at compile time. SqlCAD infers and validates data types across your entire lineage, preventing runtime failures in your warehouse.
Write Less, Do More
Stop writing repetitive boilerplate. With SqlCAD, you declare your intent, and the compiler handles the complexity of historical data, type propagation, and dialect-specific SQL generation.
- ✓ Automatic join condition injection
- ✓ SCD Type 2 history handling
- ✓ Multi-dialect support (Snowflake, BigQuery, etc.)
DEFINE ENTITY Orders {
primary_key: OrderID
type: fact
temporal: { event_time_col: OrderDate }
} AS (
SELECT * FROM RawOrders
);
DEFINE MART Dashboard AS (
SELECT
o.OrderID,
c.CompanyName,
o.OrderDate
FROM Orders o
LEFT JOIN Customers c
);CREATE OR REPLACE TABLE Dashboard AS
SELECT
o.OrderID,
c.CompanyName,
o.OrderDate
FROM Orders o
LEFT JOIN Customers c
ON c.CustomerID = o.CustomerID
AND o.OrderDate >= c.ValidFrom
AND o.OrderDate < c.ValidTo; -- Auto-injected PIT logic