Not "that anonymous user." In my experience, avoiding Join statements is a common best practice for Clickhouse users seeking performant queries on large datasets. A couple examples...
https://medium.com/datadenys/optimizing-star-schema-queries-...
https://posthog.com/blog/secrets-of-posthog-query-performanc...