How would one perform

'admin' = any(roles)

with the postgresjs?

Probably .contains('roles',['admin']) assuming roles is an array column. https://supabase.com/docs/reference/javascript/contains