There is high level public roadmap that covers the minimum features required before we'd consider going GA here:

https://supabase.github.io/pg_graphql/roadmap/

Its early days, so the conversations around aggregates haven't happened yet, but I'm optimistic that they'll make an appearance in a future release