I agree 100%, I have been using supabase a lot over the last few months and the #1 glaring wart on an otherwise pretty good system is the lack of aggregates. Fe

I agree 100%, I have been using supabase a lot over the last few months and the #1 glaring wart on an otherwise pretty good system is the lack of aggregates. Feels like a table stakes feature to at least support the very basic stuff like max, average, sum since any app that isn’t the most basic of basic apps is going to need those. And yes, I’m aware you can use an RPC or a view to work around that, but doing so very much black boxes your application logic into SQL and should be heavily avoided for several reasons and using those things come with their own limitations as well (can’t use Supabase Realtime on RPC or view, as one example).