XID8 type for db_transaction_id is not supported

[iPunjani]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

class ManifestationSnapshotAudit(BaseSQLModel, table=True):
    __tablename__ = 'snapshot_audit'

    audit_id: Optional[int] = Field(
        default=None,
        sa_column=Column(BigInteger, primary_key=True, autoincrement=True)
    )
    audit_event_time: datetime = Field(default_factory=datetime.now)
    source_system: str = Field(max_length=255)
    api_user: str = Field(max_length=255)
    entity_class: str = Field(max_length=255)
    operation_type: str
    data: dict | None = Field(sa_column=Column(JSONB))
    db_transaction_id: str

DB Schema as per liquibase yaml config --> 
databaseChangeLog:
  - changeSet:
      id: create_manifestation_snapshot_audit
      author: <user_name>
      context: audit
      changes:
        - createTable:
            tableName: snapshot_audit
            schemaName: mam
            columns:
              - column:
                  name: audit_id
                  type: BIGSERIAL
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: audit_event_time
                  type: TIMESTAMP
                  constraints:
                    nullable: false
              - column:
                  name: source_system
                  type: VARCHAR(255)
                  constraints:
                    nullable: false
              - column:
                  name: api_user
                  type: VARCHAR(255)
                  constraints:
                    nullable: false
              - column:
                  name: entity_class
                  type: VARCHAR(255)
                  constraints:
                    nullable: false
              - column:
                  name: operation_type
                  type: VARCHAR(255)
                  constraints:
                    nullable: false
                    checkConstraint: "operation_type IN ('Update', 'Insert', 'Delete')"
              - column:
                  name: data
                  type: JSONB
              - column:
                  name: db_transaction_id
                  type: XID8
                  constraints:
                    nullable: false

Description

We are using AWS Aurora postgres inbuilt method to retrieve the db_transaction_id and it generates a id of type xid8, when trying to map it from SQLModel I am always getting DataType Mismatch Error I tried to map it with str, int, BigInt, A custom class by extending TypeDecorator, Also tried by adding a pre-db-trigger that would work before any insert to snapshot_audit table and would map str to xid8 but nothing worked out, Can anyone please suggest a alternate approach or when will it get supported, In sqlAlchemy i saw some snippets online where people used to import from dialects xid type and use for that purpose.

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.19

Python Version

Python 3.11.0

Additional Context

No response