Our current approach to query-time lookups is suboptimal for ClickHouse, as it cannot effectively optimize filters even if the lookups is marked as injective.

To enhance query performance, we need to refine our query generation logic.