How to run custom SQL queries using functions in Supabase

Recently I needed to run custom SQL functions in a Supabase project. Their Javascript SDK doesn't support this so the only way is via database functions. You can then call those functions using the Javascript SDK. Let's look at a very simple example...