sqlmodel (sqlalchemy) cascade

The default behaviour when a parent object is deleted is to make the child object orphans. For related objects to delete if they are not attached to their parent, we can use the cascade property in the parent class.

class Club(SQLModel, table=True):
	id: Optional[int] = Field(default=None, primary_key=True)
	name: str
	players: List["Player"] = Relationship(
		back_populates="club",
		sa_relationship_kwargs={"cascade": "delete"},
	)