Add support for all necessary PostgreSQL types for SQLAlchemy

[chandr-andr]

Check and figure out what kind of PostgreSQL types we have to declare to make SQLAlchemy work.
It can be useful to check other dialects (psycopg/asyncpg).