PERFORM auth.soft_delete_user('00000000-0000-0000-0000-000000000000');
Supabase is a great tool for modern app development, but sometimes its out-of-the-box solutions don’t quite fit the bill, especially when it comes to soft deletes. In a recent project, we needed a way to handle this directly in SQL without relying on the Service key or spinning up an Edge function. Here’s how we approached it.