I believe that there should be a push for implementing a standard for allowing measures in SQL instead of external semantic layer standards. In this way context aware calculations could be bound to the data model and the query execution engine (and optimizer). This could also play very well into the idea of DuckLake. Please take a look at https://arxiv.org/abs/2406.00251 .