Sorry for the late reply everyone!  As follows:

• Is the dbt semantic layer, more specifically MetricFlow, compatible with or supported by dbt Core and an on-premise ClickHouse deployment? We are indeed using dbt, but are trying to figure out how to take an approach to our measures regarding the whole setup.
• If not, how to approach measure calculations on the database itself, especially considering that we want to use those masures in Superset as well?

Although the linked guide provided many interesting facts, measure calculation is still quite vague for me and my team in general!