It's great being able to use an any join (and the counterpart anti join) in Clickhouse to deal with these operations.