Possibility to delete current user without using service role key

[perostlin]

Hello,

Would like to be able to delete the currently signed in user.
This would make it possible to create an application without the need of setting up a supabase client using the service role key.

Today we use the auth admin:

const { data, error } = await supabase.auth.admin.deleteUser(
  '<guid>'
);

But would like to be able to do:

const { data, error } = await supabase.auth.deleteUser();

Similar to how the update user works.