Allow opting in to treat datetimeus as datetime rather than DatetimeUS

[gaborbernat]

For new applications/databases it might make sense to not have to deal with this historic artifact. DatetimeUS can trip up some downstream libraries like pydantic/fastapi.