Modify set profile database trigger to get data from Google metadata

[Dosbodoke]

https://boardshape.com/engineering/how-to-pull-google-profile-through-on-account-creation-with-supabase

[Dosbodoke]

Possible solution

CREATE OR REPLACE FUNCTION public.handle_new_user()
 RETURNS trigger
 LANGUAGE plpgsql
 SECURITY DEFINER
 SET search_path TO 'public'
AS $function$
BEGIN
  INSERT INTO public.profiles (id, profile_picture)
  VALUES (new.id, (SELECT raw_user_meta_data ->> 'avatar_url' FROM auth.users WHERE id = new.id))
  ON CONFLICT (id) DO NOTHING; -- Prevents error if the profile already exists
  RETURN new;
END;
$function$;