Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

https://discord.com/channels/839993398554656828/931707371464556544'

Basically you have to return a table and can't use setof if you add any column to an existing table records (for example from a join).

You have to create a return table description and specify all the columns from main table and join tables you want returned.  But I'm not much help as clear in that thread it was a learning experience.  You would have to use the sql editor though not the function ui.

Yep, the supabase UI for creating functions is **very** limited. You can look at my post directly above yours for an example of how to return a table from a function. Basically you need to know the EXACT return type of every column. Also don't expect to be able to edit your custom functions through the UI