Use standard function composition for IN operator

powersync-ja / powersync-service

Other

123 stars 9 forks source link

This allows some additional variations of the IN operator previously not supported:

-- parameter queries
SELECT WHERE request.jwt() ->> 'role' IN '["admin", "superuser"]'
SELECT WHERE 'read:users' IN (request.jwt() ->> 'permissions')
SELECT WHERE 'test' IN '["test"]'

-- data queries
SELECT * FROM assets WHERE assets.condition IN '["good","great"]'
SELECT * FROM assets WHERE 'green' IN assets.categories

This is in addition to the variations already supported before:

-- parameter queries
SELECT id FROM projects WHERE id IN request.jwt() -> 'projects'

-- data queries
SELECT * FROM assets WHERE assets.condition IN '["good","great"]'

powersync-ja / powersync-service

Use standard function composition for IN operator #93

🦋 Changeset detected