Honestly, setting up sending emails was a pain since you either have to create a public table that is locked and updated whenever email would be updated Or query auth table with another client You could try doing that with an SQL function but securing that is not possible afaik, without postgres user or RLS on a public table It's a nasty workaround