Correct UUID usage with 2.0 ORM

[hyperknot]

Hi, I'm trying to come up with a recommended UUIDv7 PK type.

import uuid
from typing import Annotated, TypeAlias

import uuid_utils
from sqlalchemy import Uuid
from sqlalchemy.orm import mapped_column


PK_UUID: TypeAlias = Annotated[
    uuid.UUID, mapped_column(Uuid, primary_key=True, default=uuid_utils.uuid7)
]

I mean the left side is stdlib's UUID, the right side is sqlalchemy.Uuid (not sqlalchemy.types.uuid, or is this an alias?). For generation I'm using uuid_utils.uuid7, until Python 3.14 gets more supported in the ecosystem.

Can you tell me if this is correct?

[CaselIT]

Hi,

Seems correct. The types module contains aliases of types, so either one is fine

[hyperknot]

Thank you. And what about sqlalchemy.UUID vs sqlalchemy.Uuid. I looked into the source code, but it's even more confusing, both supports as_uuid=True, but they are totally different. As a bonus, they both say they are "database agnostic datatypes".

class Uuid(Emulated, TypeEngine[_UUID_RETURN]):
    """Represent a database agnostic UUID datatype.

class UUID(Uuid[_UUID_RETURN], type_api.NativeForEmulated):
    """Represent the SQL UUID type.

    This is the SQL-native form of the :class:`_types.Uuid` database agnostic
    datatype, and is backwards compatible with the previous PostgreSQL-only
    version of ``UUID``.

[CaselIT]

that's documented here https://docs.sqlalchemy.org/en/20/core/type_basics.html

[hyperknot]

Thanks, so basically I need the CamelCase version.