Support for Enum Data Types in Transform Function

Why it matters

This feature enables users to utilize Enum types directly within the transform function, improving type compatibility and making it easier to map Enum values to desired outputs without explicit type conversion.

How to use it

Use the transform function with columns of Enum data type just like any other supported data type. For example:

SELECT transform(enum_column, ['EnumValue1', 'EnumValue2'], ['Result1', 'Result2']) FROM table