Wonderful write-up! What do you think the best practice is for aggregation that includes window functions or grouping (as you said this method is not recommended for these types of aggregations) if we want to keep the transformation modular and reusa...