Better organize pep 484 types in the packages #8680

Since people will probably want to use some of the type alias defined by sqlalchemy we should probably better organize them and decide what are public and what are not

Currently some are defined in _typing files, others in interfaces other in the module that uses it.