Fix a regression with ENUM data type

This reverts commit 4f476d40.

Fix CHAR in PostgreSQL mode and refactor some code

Fix issues with IN(), DISTINCT, GROUP BY, PARTITION BY and others

This reverts commit 2cdafd3a.