Don't let the model
write SQL.

Model. Deploy. Request. Run.

Four steps, three of them yours. The semantic model is YAML in git; a branch deploys as a branch.

1. 01

   model

   Tables, fields and joins in YAML

   Name a measure once. Declare joins with cardinality. The planner derives every reachable combination; you never write a query.

   models/sales/tbl.web_sales.yml

   name: Web Sales
   physical_name: web_sales
   datasource: warehouse
   cost: 100
   
   fields:
     - type: measure
       name: Web Net Paid
       data_type: decimal
       expression:
         sql: sum(ws_net_paid)

   models/sales/rel.sales.yml

   datasource: warehouse
   
   web_sales_item:
     left: Web Sales
     right: Item
     sql: left.ws_item_sk = right.i_item_sk
     cardinality: many_to_one

2. 02

   deploy

   One command, per git branch

   Secrets are stripped before upload. The service validates the model, forms the universes, runs your tests and answers with counts and warnings.

   terminal

   $ zsql deploy
   deploy tpcds (6120 bytes) as tpcds/main (the production branch) to https://app.0sql.io
   deployed tpcds/main: 6 tables, 41 fields, 7 joins, 11 paths, 1 policies
   PASSED  category by net paid
   tests: 1 passed, 0 failed

3. 03

   request

   A spec, or one line of shorthand

   Decorators for month grains and period-over-period, filters that land in WHERE or HAVING by themselves.

   POST /projects/tpcds/branches/main/sql

   {
     "spec": {
       "projections": [
         {"field": "Date", "decorators": [{"type": "truncate", "grain": "month"}], "order_by": "asc"},
         {"field": "Web Net Paid", "decorators": [{"type": "temporalize", "transform": "month_over_month"}]}
       ],
       "filters": [{"field": "Web Net Paid", "predicate": "greater_than", "value": "100"}]
     }
   }

   = the same, as shorthand: zsql sql --expr "month(date) asc, mom(web net paid), web net paid > 100"

4. 04

   run

   In your code, on your warehouse

   Top five categories by revenue: a ranking CTE joined back, no window-function guesswork. Hand it to your driver.

   response.sql

   WITH ag5c9bb8d550197b3a219ae50f0b427905 AS (
   SELECT
   	T1."i_category" AS "dim30d09b7",
   	sum(T0."ws_net_paid") AS "msr0c0d023"
   FROM
   	web_sales T0
   	JOIN item T1
   		ON T0.ws_item_sk = T1.i_item_sk
   GROUP BY
   	T1."i_category"
   ORDER BY
   	sum(T0."ws_net_paid") desc
   LIMIT 5
   )
   SELECT
   	sum(T0."ws_net_paid") AS "Web Net Paid",
   	T1."i_category" AS "Category"
   FROM
   	web_sales T0
   	JOIN item T1
   		ON T0.ws_item_sk = T1.i_item_sk
   	INNER JOIN ag5c9bb8d550197b3a219ae50f0b427905 AS A2
   		ON T1."i_category" = A2.dim30d09b7
   GROUP BY
   	T1."i_category"