SQLModel relationship without being a table?

[joshua-brumpton-uniper]

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 typing import Optional
from uuid import UUID, uuid4

from sqlmodel import SQLModel, Relationship, Field


class Citation(SQLModel, table=True):
    
    id: Optional[UUID] = Field(
        default_factory=uuid4,
        primary_key=True,
        description="The unique identifier of the citation",
    )
    content: str
    message_id: UUID | None = Field(
        foreign_key="message.id",
        ondelete="CASCADE",
        index=True,
        description="The unique identifier of the message the citation belongs to",
    )
    message: "Message" = Relationship(
        back_populates="citations", sa_relationship_kwargs={"lazy": "selectin"}
    )


class Message(SQLModel, table=True):

    id: Optional[UUID] | None = Field(
        default_factory=uuid4,
        primary_key=True,
        description="The unique identifier of the message",
    )
    conversation_id: UUID | None = Field(
        foreign_key="conversation.id",
        ondelete="CASCADE",
        index=True,
        description="The unique identifier of the conversation the message belongs to",
    )
    content: str
    conversation: "Conversation" = Relationship(
        back_populates="messages", sa_relationship_kwargs={"lazy": "selectin"}
    )
    citations: list["Citation"] = Relationship(
        back_populates="message",
        sa_relationship_kwargs={"lazy": "selectin", "cascade": "all, delete-orphan"},
    )


class Conversation(SQLModel, table=True):

    id: Optional[UUID] | None = Field(
        default_factory=uuid4,
        primary_key=True,
        description="The unique identifier of the conversation",
    )
    title: str
    creator_id: int
    messages: list["Message"] = Relationship(
        back_populates="conversation",
        sa_relationship_kwargs={"lazy": "selectin", "cascade": "all, delete-orphan"},
    )

Description

This works perfectly BUT I don't need or want to persist the citations to a table in the database. How would I refactor this code to work in at least a very similar way without having a physical Citation table? Particularly I want to be able to get a conversation and its message models within that and the citation models within those automatically.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.21

Python Version

3.12.1

Additional Context

No response