Fix CHAR in PostgreSQL mode and refactor some code

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

This reverts commit 2cdafd3a.