Manual Crono SQL

Write it once. Load it into any engine.

What is Crono SQL?

Extended SELECT

Simplified JOINs, reusable calculated columns, query stacking, SEMI JOIN, ANTI JOIN and MATERIALIZE. All standard SQL keeps working without changes.

Load patterns

MERGE CLONE, MERGE UPSERT, MERGE HISTORY and more. Each statement creates the table, evolves it when you add fields and manages audit columns automatically.

Portable functions

Text, numeric, date and aggregation functions that compile correctly on all supported engines, without dialect incompatibilities.

Supported engines

Snowflake

Redshift

BigQuery

SQL Server

PostgreSQL

Databricks

MS Fabric

DuckDB

Simplified syntax

Crono SQL
 MERGE CLONE dwh.dim_products KEY (product_id)
SELECT
  products.product_id,
  products.product_name,
  categories.category_name,
  suppliers.company_name supplier
FROM staging.products
INNER JOIN staging.categories USING category_id
INNER JOIN staging.suppliers USING supplier_id 

Interactive Playground

Write Crono SQL and see in real time the SQL generated for each database engine.

Try this example

Main statements

SELECT Simplified JOINs, reusable columns and query stacking

MERGE CLONE Full sync: creates the table, maintains it and manages audit

MERGE UPSERT Inserts new records and updates existing ones (SCD Type 1)

MERGE HISTORY Maintains complete history of changes (SCD Type 2)

MERGE SOFT DELETE Marks as deleted records that no longer exist in source

INSERT OVERWRITE Full reload: deletes and reinserts all records

INSERT IF NEW Inserts only new records, without modifying existing ones

CHECK SNOWFLAKE Verifies that JOINs do not lose or duplicate records

MATERIALIZE Defines temporary tables to simplify complex queries

Built-in functions

Crono SQL supports all native functions of each engine and adds its own functions like:

margin(a, b) Safe sales margin

markup(a, b) Safe markup

divide(a, b) Safe division (no /0 error)

substraction(a, b) Safe subtraction