Grammar Reference (Sync Streams)

SELECT id, name FROM users WHERE active = true

name AS user_name

users.id

users

users AS u

json_each(data)

json_each(data) AS items

(SELECT id FROM users) AS u

JOIN orders ON users.id = orders.user_id

active = true AND age > 18

age BETWEEN 10 AND 100

IN (SELECT id FROM users)

(SELECT id FROM users)

price * quantity + tax

->'address'->>'city'

(price + tax)

CASE WHEN age >= 18 THEN 'adult' ELSE 'minor' END

CASE WHEN x > 0 THEN 'positive' ELSE 'negative' END

WHEN age >= 18 THEN 'adult'

x > 0 AND y IS NOT NULL

CASE status WHEN 1 THEN 'active' WHEN 0 THEN 'inactive' END

WHEN 1 THEN 'active'

CAST(age AS TEXT)

upper(name)

SELECT id FROM orders WHERE orders.user_id = users.id

SELECT id, upper(name) AS display_name FROM users WHERE active = true