I know, but I'm looking for aggregating data e.g.: A category has many expenses -> each expense has an amount -> querying categories with

total_amount_expenses

You can create either a Postgres view to handle this or create a Postgres function and call it via the

.rpc

method of the supabase library.

Ah, thanks for the suggestions. I'll look into that. Really enjoying Supabase so far 🙂