Currently, in CPython, we have two separate objects to handle timestamps and timezones, but there is no single object that combines both concepts into one coherent representation of a "timestamp with ...
The default setting for sqlalchemy.DateTime columns on postgres databases is on timezone=True, while pythons default setting for datetime stuff seems to be timezone=False, hence the two defaults ...
When trying to make things work with the datetime module, most Python users have faced a point when we resort to guess-and-check until the errors go away. datetime is one of those APIs that seems easy ...