How to query all replies in a comment model without using remote_side in SQLModel?

[tangyh001]

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 Comment(CustomModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    article_id: Optional[int] = Field(
        default=None,
        index=True,
        sa_column_kwargs={'comment': 'comment1'},
    )
    content: str = Field(
        nullable=False,
        sa_column=Column('content', Text, comment='comment'),
    )
    author_id: Optional[int] = Field(default=None, index=True)
    comment_id: Optional[int] = Field(default=None, foreign_key='comment.id')
    created_at: Optional[datetime] = Field(
        default=None,
        nullable=False,
        sa_column_kwargs={'server_default': text("CURRENT_TIMESTAMP")},
    )
    updated_at: Optional[datetime] = Field(
        default=None,
        nullable=False,
        sa_column_kwargs={
            'server_default': text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'),
        },
    )
    replys: List['Comment'] = Relationship(back_populates="comment", sa_relationship_kwargs={'uselist': True, 'remote_side': 'Comment.id'})

    comment: Optional["Comment"] = Relationship(back_populates="replys", sa_relationship_kwargs={'uselist': False})

Description

How to query all replies in a comment model without using remote_side in SQLModel?

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.10

Additional Context

No response