That's only works for sql optimized case / queries, aggregation with indexed keys is one of them. However there are cases where application level is more optimi

That's only works for sql optimized case / queries, aggregation with indexed keys is one of them. However there are cases where application level is more optimized, such as cases where more complex data type is required, or array processing. Furthermore sql logic cannot be easily encapsulated and reuseable, which leaves you with many duplication without proper planning.