Fix CHAR in PostgreSQL mode and refactor some code

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

This reverts commit 2cdafd3a.

Assorted fixes for ALTER TABLE ALTER COLUMN