Add user with metadata to public users using functions

begin
  insert into public.users (id, email, first_name, last_name)
  values (new.id, new.email, new.raw_user_meta_data.first_name, new.raw_user_meta_data.last_name);
  return new;
end;

// sign up the user
const { data, error: e } = await locals.supabase.auth.signInWithOtp({
    email: body.email,
    options: {
        data: {
            first_name: body.first_name,
            last_name: body.last_name
        }
    }
});

"e": {
     "name": "AuthApiError",
      "message": "Database error saving new user",
      "status": 500
}