Relationships with dicts not working anymore

[jordi-petit]

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

from sqlalchemy.ext.declarative import declared_attr
from sqlalchemy.orm.collections import attribute_mapped_collection

from sqlmodel import Relationship, Field, SQLModel


class Element(SQLModel, table=True):

    element_id: str = Field(default=None, primary_key=True)
    title: str

    sublement: dict[str, "SubElement"] = Relationship(
        sa_relationship_kwargs={
            "collection_class": attribute_mapped_collection("subelement_id"),
        }
    )


class SubElement(SQLModel, table=True):

    element_id: str = Field(default=None, primary_key=True)
    subtitle: str

    element: Element = Relationship(back_populates="Element", sa_relationship_kwargs={"lazy": "joined"})

Description

I wish to have a relationship attribute made of a dict rather than a list.

In sqlmodel-0.0.8 this code was working well.

However, in sqlmodel-0.0.16 I get this error:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "foo/src/m.py", line 7, in <module>
    class Element(SQLModel, table=True):
  File "foo/env/lib/python3.10/site-packages/sqlmodel/main.py", line 524, in __init__
    relationship_to = get_relationship_to(
  File "foo/env/lib/python3.10/site-packages/sqlmodel/_compat.py", line 157, in get_relationship_to
    return get_relationship_to(
  File "foo/env/lib/python3.10/site-packages/sqlmodel/_compat.py", line 157, in get_relationship_to
    return get_relationship_to(
  File "foo/env/lib/python3.10/site-packages/sqlmodel/_compat.py", line 157, in get_relationship_to
    return get_relationship_to(
  [Previous line repeated 983 more times]
  File "foo/env/lib/python3.10/site-packages/sqlmodel/_compat.py", line 128, in get_relationship_to
    origin = get_origin(annotation)
  File "/usr/lib/python3.10/typing.py", line 1919, in get_origin
    if isinstance(tp, (_BaseGenericAlias, GenericAlias,
RecursionError: maximum recursion depth exceeded in __instancecheck__

I am not able to tell if the problem is in SQLModel, SQLAlchemy or in typing.

Or should this be done in a different way?

Operating System

Linux

Operating System Details

Linux 5.15.0-92-generic #102-Ubuntu SMP 86_64 x86_64 x86_64 GNU/Linux

SQLModel Version

0.0.8 vs 0.0.16

Python Version

Python 3.10.12

Additional Context

No response