How are the aggregates optimized? Why is it better to use aggregate and retrieve whole data from entities than write advanced SQL and retrieve only what you need.  I watched videos and everywhere it is said, that you should only use advanced SQL in case when aggregates can not retrieve data the way you need and that's the extreme case I guess. But I still wonder why is it better.