In my application, users are signing up/in with Phone Number. I'd like to also add and verify an email to their account (for recovery and newsletter purposes) but I can't find a way to add it to the user's row in

auth.users

table from client libraries. The only solution I found was to create a

public.profiles

table (with a

user_id

foreign key that points to

auth.users

id

field) and add an

email

field along with other custom data associated to the user, but this way I can't leverage on Supabase Auth's email confirmation. Does someone have some advice on how to do it better?