We should consider supporting the Postgres syntax for all of the types whose Postgres OID we support via pgwire and claim to support via pg_catalog.pg_type.

For instance, our integer type is named INT, but we support the int2, int4, and int8 types via their OID in pgwire and in pg_type. We should consider supporting using the type names INT2, INT4, and INT8 as syntax in SQL statements. They would just be aliases for our INT type, the same way their OIDs are, since we don't support storing integers smaller than int8.