deleteOwnAccount method
Permanently delete the current user's account and all associated data. Calls a SECURITY DEFINER RPC that handles FK cleanup and auth.users deletion.
Implementation
Future<void> deleteOwnAccount() async {
await _client.rpc('delete_own_account');
}