Starting from v.25.2. you ClickHouse can infer comparing conditions for better use of PK or indexes. More on this: here.