Applying any condition to any data type

The selection of conditions is always based on the first argument in the condition, making it impossible to apply conditions specific to certain data types in cases where a column of that data type is the second argument. It is not always possible to swap the two, so it would be helpful to be able to override the default selection and be able to apply any condition to any data type. Even if it doesn't seem to make sense, it is the level of control required to be able to ship great UX.

I would like to specifically point out the array conditions situation. I should be able to apply "is (not) contained in" conditions to a string to be able to compare it with an array column being the second argument