Proper Error Propagation for Triggers on auth.users Table

Hey Supabase team! 👋

I’m using Supabase with an OAuth provider in my NextJS app, and I ran into an issue with error handling.
When a trigger function on the auth.users table raises an exception, the error doesn’t make its way back to the /api/auth/callback endpoint.
Right now the query param error_description just says Database error saving new user and the error_code is 500,
which makes it really hard to handle edge case flows if I have some custom logic around user creation.