Allow Implicit String Comparisons for Index Condition Analysis

Why it matters

This feature improves query optimization by enabling implicit conversions for index condition analysis when constant strings are compared with columns of different types. It addresses issues where such comparisons previously failed to use indexes effectively, thereby enhancing query performance and usability.

How to use it

Users do not need to change their queries explicitly. When writing comparisons between columns of non-string types and constant string literals in WHERE or index condition expressions, ClickHouse will automatically apply implicit conversions to utilize indexes wherever applicable.