Yes, you can do everything with postgres. Supabase even has an extension that allows you to send http requests from Sql.

But for me writing stored functions is not that fun, instead it would be better to use a different language, and write code that generates all the pl/pgslq and manages stored functions for me.

Kind of like code in lisp, then deploy generated code to postgres.

I dont know about you guys but writing "create or replace function ..." boilerplate again and again manually gives me wrist pain.