Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

How to implement custom user roles in JWT, and auth.users ?
To write policies like that:
```
create policy "Only CUSTOM_ROLE can create posts" on posts for
    select using (auth.role() = 'CUSTOM_ROLE');
```
How to change role column in auth.users ?

Solved it with this approach:
```
(
  EXISTS (
    SELECT *
    FROM
      users
    WHERE
      (
        (users.id = uid())
        AND ((users.role):: text = 'ADMIN':: text)
      )
  )
)
```
Need public.users table with the same id as in auth.users.
https://supabase.io/docs/guides/auth/managing-user-data

But why we need to stuff like this?
Why not do it like in Hasura? User role is added to JWT claim?
<@!414972572732489748>

Ah see it
https://github.com/supabase/supabase/discussions/1148#discussioncomment-608932

Good article
https://cazzer.medium.com/designing-the-most-performant-row-level-security-strategy-in-postgres-a06084f31945