I'm using SQLModel and would like to define base class with created_at field to inherit from it in others models. class CreatedAtMixin(SQLModel): created_at: datetime = Field(default=datetime.now(...

I have a database of companies in a hierarchical structure where all the companies are in the same table but each refer to a parent company that is referenced in a parent_id column. This value matches...

Does anyone know if its possible to get a INSERT OR IGNORE function with SQLModel? And if not, does anyone know if there is a workaround to get the same results? I haven't tried anything to get the re...

Recently I came across SQLModel package. It combines pydantic and sqlalchemy features to work with database objects. What I noticed in documentation is that table=True parameter that you use to declar...