Based on what you are asking for could you not use an auth trigger https://supabase.com/docs/guides/database/postgres/triggers to populate any information that you need when an auth user is updated e.g. auth.users.is_confirmed_at

Yeah @k1ng-arthur's pointer is the standard path. Sketch: a public.profiles table referencing auth.users(id) with RLS, plus create trigger on_auth_user_created after insert on auth.users for each row execute function handle_new_user(); where the function inserts a profile row from new.id / new.email / new.raw_user_meta_data. Use security definer and set search_path = public on the function. Full recipe is in Supabase's "Managing User Data" guide.