SAP Hana is taking your approach to aggregation. See Hana Calculation views.

For joins it takes a different route. You create a calculation view with all tables being joined but the optimizer strips away all joins that are not needed when executing an actual select on the view.

https://blogs.sap.com/2019/08/26/what-is-the-difference-calcview-versus-sql-view/