cannot cast type uuid[] to uuid - Regression between versions 0.0.8 and 0.0.16 using pydantic 1.10.7

[RaamEEIL]

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

import threading
from datetime import datetime
from typing import Optional
from uuid import UUID

from fastapi import Depends
from sqlalchemy.dialects.postgresql import UUID as UUIDSA
from sqlalchemy.future import Engine
from sqlmodel import Field, SQLModel, Column, DateTime, JSON, text, MetaData, Session, create_engine

from infrastructure.databases.analyses_db_manager.config_store import (
    analyses_db_manager_config,
    environment_vars,
    ConfigDatabaseModel,
    DbServerNames,
)

analyses_metadata = MetaData(schema="analyses")

lock = threading.Lock()


def get_session():
    engine = f"{db_plus_framework}://{user}:{password}@{host}:{port}/{name}"
    return Session(engine)


class AnalysisTasksSqlModel(SQLModel, table=True):
    __tablename__ = "tasks"
    metadata = analyses_metadata

    id: Optional[int] = Field(primary_key=True, index=True)
    uid: Optional[UUID] = Field(
        sa_column=Column(
            UUIDSA(as_uuid=True),
            server_default=text("gen_random_uuid()")
        ), default=None
    )
    session_id: Optional[int]
    created: Optional[datetime] = Field(sa_column=Column(DateTime(timezone=True), nullable=False))
    completed: Optional[datetime] = Field(
        sa_column=Column(DateTime(timezone=True), nullable=True)
    )
    details: dict = Field(sa_column=Column(JSON), default={})
    output_folder_uid: UUID = Field(index=True, nullable=False)
    input_folder_uids: list[UUID] = Field(
        sa_column=Column(
            UUIDSA(as_uuid=True),
            server_default=text("gen_random_uuid()")
        ), default=None
    )


data = {
    "session_id": 232,
    "details": {
        "analysis_name": "TestAnalysis",
        "input_folders": [
            "edecd2c7-3fa2-4266-be3f-c7491309f8be"
        ],
        "log_group_uid": "94081ca3-fd7e-46a1-881b-81247bcd04b0",
        "output_folder": "d5decbb8-625c-49e9-8788-751d95a684fc",
        "input_metadata": {
            "mov_filename": "recording1.mov"
        },
        "analyses_session": "f41bd637-2865-4495-9dbc-5def00c03dc0",
        "storage_session": "15a55a67-1acf-446e-ab27-44f0f459d87e",
        "project_codename": "automation_dev",
        "blocking_storage_task_uids": [
            "aa3e5c6c-d38b-4d56-887e-7a024ac8f3e5"
        ],
        "human_readable_folder_name": "folder_001",
        "blocking_analyses_task_uids": []
    },
    "output_folder_uid": "d5decbb8-625c-49e9-8788-751d95a684fc",
    "input_folder_uids": [
        "edecd2c7-3fa2-4266-be3f-c7491309f8be"
    ]
}

table_create_script="""
CREATE TABLE IF NOT EXISTS analyses.tasks
(
    uid uuid NOT NULL DEFAULT uuid_generate_v4(),
    created timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    completed timestamp with time zone,
    id bigint NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
    session_id bigint,
    output_folder_uid uuid NOT NULL DEFAULT uuid_generate_v4(),
    input_folder_uids uuid[] NOT NULL,
    details jsonb NOT NULL,
    CONSTRAINT tasks_pkey PRIMARY KEY (id),
    CONSTRAINT task_unique_id UNIQUE (uid),
    CONSTRAINT session_id_fkey FOREIGN KEY (session_id)
        REFERENCES analyses.sessions (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)"""

def create_task(task: AnalysisTasksSqlModel, session: Session):
    session.add(task)
    try:
        session.commit()
    except Exception as e:
        raise HTTPException(status_code=500, detail=str(e))
    session.refresh(task)
    return task


task = AnalysisTasksSqlModel(**data)

create_task(task, get_session())

Description

I hope this is enough information.

Issue:
Moving from SQLModel 0.0.8 to 0.0.13 or 0.0.16 broke the functionality of casting a list of UUIDs.

causes this error

"detail": "(psycopg2.errors.CannotCoerce) cannot cast type uuid[] to uuid

{
"detail": "(psycopg2.errors.CannotCoerce) cannot cast type uuid[] to uuid\nLINE 1: ...RRAY['edecd2c7-3fa2-4266-be3f-c7491309f8be'::uuid]::UUID) RE...\n ^\n\n[SQL: INSERT INTO analyses.tasks (session_id, created, completed, details, output_folder_uid, input_folder_uids) VALUES (%(session_id)s, %(created)s, %(completed)s, %(details)s, %(output_folder_uid)s::UUID, %(input_folder_uids)s::UUID) RETURNING analyses.tasks.id, analyses.tasks.uid]\n[parameters: {'session_id': 232, 'created': None, 'completed': None, 'details': '{"analysis_name": "TestAnalysis", "input_folders": ["edecd2c7-3fa2-4266-be3f-c7491309f8be"], "log_group_uid": "94081ca3-fd7e-46a1-881b-81247bc ... (375 characters truncated) ... blocking_storage_task_uids": ["aa3e5c6c-d38b-4d56-887e-7a024ac8f3e5"], "human_readable_folder_name": "folder_001", "blocking_analyses_task_uids": []}', 'output_folder_uid': 'd5decbb8-625c-49e9-8788-751d95a684fc', 'input_folder_uids': [UUID('edecd2c7-3fa2-4266-be3f-c7491309f8be')]}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"
}

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.16

Python Version

Python 3.11.2

Additional Context

No response

[RaamEEIL]

A workaround will be appreciated if this is a known bug. Thanks.