Add support for normalizing SET statements, cleanup tests.
Add tests for additional statements.

ALTER TABLE, COPY, DROP, BEGIN/COMMIT/..., VACUUM, EXPLAIN,
CREATE TABLE AS, SET, SHOW, LOCK, CHECKPOINT.