UUID for postgreSQL

[chris-han]

Things to check first

• I have searched the existing issues and didn't find my feature already requested there

Feature description

3.0.0RC5 generated model for pgsql using generic uuid type uuid.UUID, which need to be manually converted to the UUID type from sqlalchemy.dialects.postgresql:
from sqlalchemy.dialects.postgresql import UUID

from:
uuid: Mapped[uuid.UUID] = mapped_column(Uuid, primary_key=True)
to:
uuid: Mapped[UUID] = mapped_column(Uuid, primary_key=True)

Use case

You'll need this every time you generate the models from pgsql which contains uuid type.

[dominusmi]

Pushed a possible fix. A bit hacky but give it a look. Tested locally on my database and works, wanted to run the repo tests and potentially add a test for this case, but they seem to be failing on master

[sheinbergon]

@dominusmi repo tests are now passing as expected. Tests are failing due to bad imports.
@agronholm generally speaking, what do you thing about #332? Doesn't sound like a bad idea to me?

[agronholm]

The import naming scheme in this project was supposed to rename conflicting imports by adding underscores (can't remember if by prepending or appending). The example in the description doesn't match the linked PR btw.

[agronholm]

Anyway, the real fix would be figuring out why the import renaming mechanism isn't working as expected.