In SQL the EXISTS clause is quite useful for checking specific conditions without having to join. For example looking for a user which doesn’t belong to a group :
SELECT * FROM users u WHERE NOT EXISTS
(SELECT 1 FROM users_groups ug WHERE ug.user_id = u.id)
Is there an equivalent to this type of query in the Supabase Javascript Client library ? I have looked at the docs but can’t seem to find anything.