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

Supabase

can i query the auth.users able directly then?

You can do an rpc call to a security definer function and do it.

You can also write to another table when it changes with a trigger, if the overhead makes sense

ok, just so i understand,  i can create a security definer function to get the data i need from the auth.users table and either call it via rpc, or trigger it to update on a table in my public scema?

Yes.  The trigger is like the supabase example to populate a user info table in public schema which it sounds like you have.  Just on update versus insert.