Support LIKE Operator for Enum Data Type in ClickHouse

Why it matters

This feature enables users to perform pattern matching queries on Enum columns using string search operators like LIKE. It solves the limitation where Enum types previously could not be used with these operators, enhancing query flexibility and expressiveness for enumerated types.

How to use it

Users can now apply string search operators such as LIKE directly on Enum columns within their SQL queries, for example:

SELECT * FROM table WHERE enum_column LIKE 'pattern%'