Move business logic into postgresql functions

[hamish-rocket-science]

There is a load of business logic that could be handled in PostgreSQL functions (eg. fixture generation)

https://supabase.com/docs/guides/database/functions