This inspired me to dig around a little more, and the details at https://clickhouse.com/docs/en/operations/settings/settings#settings-join_algorithm https://cli

This inspired me to dig around a little more, and the details at https://clickhouse.com/docs/en/operations/settings/settings#settings-join_algorithm https://clickhouse.com/docs/en/operations/settings/settings#... leave me more confident you can do large joins if your flow requires them. It still looks like CH's default setting is extra work if you're used to writing queries and letting the query planner worry about join strategies.