A columnar database for analytics, written in Zig, that you query with rollup-friendly SQL

CREATE ROLLUP ticks_r ON ticks
  KEY (sym)
  AGGREGATE (sum(qty) AS vol,
    min(px) AS lo, max(px) AS hi,
    last_value(px) AS last)
  RESOLUTIONS (1s, 1m, 1h);

SELECT toStartOfHour(ts) AS hour,
  sum(qty) AS volume, min(px) AS low,
  max(px) AS high,
  last_value(px) AS last
FROM ticks
WHERE sym = 'NVDA'
GROUP BY hour
ORDER BY hour
LIMIT 3

SELECT country, count(*) AS orders,
  round(sum(amount), 2) AS revenue
FROM iceberg.orders
WHERE status = 'shipped'
GROUP BY country
ORDER BY revenue DESC
LIMIT 3

SELECT formatDateTime(t.ts, '%T')
         AS time,
       t.px, q.bid, q.ask,
       round(t.px - (q.bid + q.ask) / 2,
             3) AS vs_mid
FROM trades t
ASOF JOIN quotes q USING (sym, ts)
ORDER BY t.ts DESC
LIMIT 3

CREATE INDEX tickets_body
  ON tickets (body)
  TYPE fulltext(min_gram = 3);

SELECT id, subject, opened
FROM tickets
WHERE hasToken(body, 'refund')
ORDER BY bm25Score(body,
  'refund card') DESC
LIMIT 3

CREATE POLICY mask_email ON customers (email)
  FOR ROLE viewer AS ANONYMIZE HASH;
CREATE POLICY no_mrr ON customers (mrr)
  FOR ROLE viewer AS REJECT;

-- run as a viewer
SELECT customer_id, email, plan
FROM customers
ORDER BY customer_id