Grammar Reference (Sync Rules)

SELECT id FROM users WHERE id = token_parameters.user_id

SELECT value FROM json_each(token_parameters.tags)

SELECT id, name FROM users WHERE org_id = token_parameters.org_id

SELECT token_parameters.user_id AS id

SELECT id, name FROM users WHERE users.id = bucket.user_id

name AS user_name

JSON_EACH(token_parameters.tags)

users.id = bucket.user_id AND active = true

status IS NOT NULL

price * quantity + tax

->'address'->>'city'

users.id

CAST(age AS TEXT)

upper(name)

(price + tax)