Hello, I'm not sure if it is possible, but it would be great if Npgsql would support more Aggregate Functions, especially when using Group By queries.

Currently only a few of the list at: https://www.postgresql.org/docs/current/functions-aggregate.html are support.
However it would be good if others like bool_and or bool_or will be supported.

I'm not sure if it is even possible since I didn't see custom pgsql only aggregate functions (yet), also it might be troublesome to work with IGrouping<anon type, anon type>.

Work:

• Sync EF Core and implement custom aggregate infrastructure #2393
• Basic PostgreSQL custom aggregate translations #2395
• Support for statistical aggregate functions #532
• Translate basic aggregate spatial functions #2384
• Implement sum and avg PG interval #2339
• Support range aggregate functions over NodaTime Interval and DateInterval #2481