lol for sure, I'm genuinely curious though, like maybe op is a clickhouse dev? Or maybe they had the cursed idea and decided clickhouse was the best fit for various reasons?
Postgres does not have incremental view maintenance for its materialized views like clickhouse does. This means the implementation strategy would need to be quite different. Perhaps triggers is enough and of course if you use functions then sure, you can make an emulator there too.