Support Numeric Values for Enums Directly in IN Section

Why it matters

This feature allows users to specify Enum values as their underlying numeric representations directly in the IN section. It resolves the limitation of needing to use Enum labels as strings, thus enabling more flexible and concise queries, especially when numeric IDs are more convenient or available.

How to use it

Users can now write queries with Enum columns by directly using their numeric values inside the IN clause. For example:

SELECT * FROM table WHERE enum_column IN (1, 2, 3)

, where 1, 2, 3 are valid numeric values of the Enum.