Use Time Zone for DateTime Comparisons to Fix Issue #5206

Why it matters

This feature fixes an issue where comparisons between DateTime columns and string literal values did not take the time zone into account, leading to incorrect query results. By using the time zone properly, it ensures that date and time comparisons behave as expected, improving query accuracy and reliability.

How to use it

Users don't need to change their queries explicitly. When comparing a DateTime column to a string literal, ClickHouse automatically applies the time zone for accurate comparison.