Timestamp columns with time zone map to `UserDefinedType` rather than `TIMESTAMP`

[hammerhead]

Description
Given this table:

CREATE TABLE IF NOT EXISTS "doc"."t1" (
   "ts" TIMESTAMP,
   "tsw" TIMESTAMP WITH TIME ZONE,
   "tswo" TIMESTAMP WITHOUT TIME ZONE
)

On inspection of columns:

from sqlalchemy import create_engine
from sqlalchemy import inspect

engine = create_engine("crate://localhost")
inspector = inspect(engine)

for col in inspector.get_columns("t1"):
    print(f"{col["name"]} {col["type"]}")

Actual behaviour
The following output is returned:

ts UserDefinedType()
tsw TIMESTAMP
tswo UserDefinedType()

Expected behaviour
All three columns should map to TIMESTAMP.

[amotl]

Hi. Without looking at the details, I can report that many improvements are piling up, including some for the type mapping scenery.

• Types: Add support for BINARY columns and improve support for FLOATs #12
• Types: Add method ObjectArray.as_generic #23
• Types: Improve type mappings #24

There is a chance the most important improvements have been included into the most recent development release. So, can I you ask you to try 0.42.0.dev2 for fun and report back?

[hammerhead]

Thank you, I can confirm the output changes to the following with 0.42.0.dev2:

ts TIMESTAMP
tsw TIMESTAMP
tswo TIMESTAMP

[kneth]

@amotl @surister Should we release 0.42.0.dev2 as 0.42.0?

[surister]

@amotl @surister Should we release 0.42.0.dev2 as 0.42.0?

not without adding tests first