Add psycopg2 type overrides to DBAPI

Does this mean the conversions only work one way? i.e. the sql layer will return a string for datetimes? Shouldn't it return a datetime?