Overview

16 Pull requests merged by 4 people

• ⬆ Bump typer from 0.17.3 to 0.17.4

  #1554 merged Sep 8, 2025

• ⬆ [pre-commit.ci] pre-commit autoupdate

  #1546 merged Sep 5, 2025

• ⬆ Bump ruff from 0.12.10 to 0.12.12

  #1548 merged Sep 5, 2025

• ⬆ Bump typer from 0.16.1 to 0.17.3

  #1547 merged Sep 5, 2025

• ⬆ Bump pypa/gh-action-pypi-publish from 1.12.4 to 1.13.0

  #1550 merged Sep 5, 2025

• 👷 Detect and label merge conflicts on PRs automatically

  #1552 merged Sep 5, 2025

• ✏️ Fix typos in docs/tutorial/relationship-attributes/cascade-delete-relationships.md

  #1543 merged Aug 27, 2025

• ⬆ Bump ruff from 0.12.9 to 0.12.10

  #1532 merged Aug 26, 2025

• ⬆ [pre-commit.ci] pre-commit autoupdate

  #1534 merged Aug 26, 2025

• ⬆ Bump typer from 0.16.0 to 0.16.1

  #1531 merged Aug 19, 2025

• ⬆ Bump actions/download-artifact from 4 to 5

  #1451 merged Aug 19, 2025

• ⬆ Bump actions/checkout from 4 to 5

  #1488 merged Aug 19, 2025

• ⬆ [pre-commit.ci] pre-commit autoupdate

  #1479 merged Aug 19, 2025

• ⬆ Bump mkdocs-macros-plugin from 1.3.7 to 1.3.9

  #1507 merged Aug 19, 2025

• ⬆ Bump ruff from 0.12.7 to 0.12.9

  #1521 merged Aug 19, 2025

• ⬆ Bump mkdocs-material from 9.6.16 to 9.6.17

  #1528 merged Aug 19, 2025

7 Pull requests opened by 3 people

• ⬆ Bump typing-extensions from 4.13.2 to 4.15.0

  #1537 opened Aug 26, 2025

• ⬆ Bump actions/labeler from 5 to 6

  #1549 opened Sep 4, 2025

• ⬆ Bump actions/setup-python from 5 to 6

  #1551 opened Sep 4, 2025

• ⬆ Bump griffe-typingdoc from 0.2.8 to 0.2.9

  #1553 opened Sep 5, 2025

• 📝 Add migrations section

  #1555 opened Sep 7, 2025

• ⬆ [pre-commit.ci] pre-commit autoupdate

  #1556 opened Sep 8, 2025

• ⬆ Bump mkdocs-material from 9.6.17 to 9.6.19

  #1557 opened Sep 8, 2025

88 Issues closed by 6 people

• Pyright type checking when working with aggregate data

  #450 closed Sep 7, 2025

• SQLModel inheritance breaks sqlalchemy mutation tracking

  #468 closed Sep 7, 2025

• Unsure how to specify foreign keys when receiving AmbiguousForeignKeysError

  #10 closed Aug 27, 2025

• `Unexpected argument(s)` warning in PyCharm when using `select()` with many parameters

  #92 closed Aug 27, 2025

• Pydantic Validators does not raise ValueError if conditions are not met

  #134 closed Aug 27, 2025

• How to create computed columns ?

  #150 closed Aug 27, 2025

• How to specify schema when using SQLServer

  #163 closed Aug 27, 2025

• Issue using from_orm stripping Relationship data from models

  #224 closed Aug 27, 2025

• Unable to use original type hint by defining relationship

  #228 closed Aug 27, 2025

• How to use two different metadata properly to connect to two databases?

  #264 closed Aug 27, 2025

• I get type error if I use __root__ from pydantic while inheriting from SQLModel

  #281 closed Aug 26, 2025

• Switch from `str` to `EmailStr` errors `alembic revision --autogenerate` with exit code 1 and no stack trace

  #289 closed Aug 26, 2025

• AttributeError while creating object with nested data/model

  #293 closed Aug 26, 2025

• Can't connect to a local, existing MySQL DB

  #295 closed Aug 26, 2025

• select specific columns returning Row objects instead of ORM class, load_only() doesn't work

  #337 closed Aug 26, 2025

• IAM authentication token does not work in Postgres connection string

  #340 closed Aug 26, 2025

• Is it possible to instantiate a SQLModel object with relationships from a `dict` type?

  #342 closed Aug 26, 2025

• UnmappedInstanceError exception with (wrongly) unrefreshed model object

  #351 closed Aug 26, 2025

• The field name is python keywords, the field type is Mysql8.0 JSON

  #203 closed Aug 26, 2025

• Problem with the metadata field (NameError: Field name "metadata" shadows a BaseModel attribute; use a different field name with "alias='metadata'".)

  #290 closed Aug 26, 2025

• There seems to be a bug in using model with aliased fields to define request body

  #374 closed Aug 26, 2025

• Creating column with an alias name

  #93 closed Aug 26, 2025

• .exec() with text() does not provide auto-suggestion methods

  #376 closed Aug 26, 2025

• Migrations with UUID and server_default fail.

  #491 closed Aug 26, 2025

• How to make a double foreign key as a primary key

  #463 closed Aug 26, 2025

• Data Integrity: Raise error on attempt to delete an object required via a Relationship

  #533 closed Aug 16, 2025

• [M2M] Query dependent incl. `link_model` fields

  #535 closed Aug 16, 2025

• Get select with options (selectinload) using response schema

  #538 closed Aug 15, 2025

• Obtaining `TypeError: Cannot pickle 'module' object` on models with many-to-many relationships

  #540 closed Aug 15, 2025

• Order of columns in the table created does not have 'id' first, despite the order in the SQLModel. Looks like it's prioritising fields with sa_column

  #542 closed Aug 15, 2025

• Cyclic import error with Multiple files

  #1358 closed Aug 15, 2025

• Database loss of connection after extended period of inactivity.

  #60 closed Aug 15, 2025

• postgreSQL: SQLModel.metadata.create_all(engine) doesn't create the database file

  #66 closed Aug 15, 2025

• TypeError: issubclass() arg 1 must be a class when having a field with a complex type

  #67 closed Aug 15, 2025

• sqlalchemy.exc.CompileError: Can't generate DDL for NullType(); did you forget to specify a type on this Column?

  #69 closed Aug 14, 2025

• calling `sqlalchemy.orm.aliased` on inherited SQLModel throws exception `sqlalchemy.exc.NoInspectionAvailable: No inspection system is available for object of type <class 'sqlmodel.main.SQLModelMetaclass'>`

  #71 closed Aug 14, 2025

• Can't use set in model_obj.dict(exclude=...)

  #73 closed Aug 14, 2025

• async - can't access parent.child item (relationship models) using async

  #74 closed Aug 14, 2025

• Multiple many-to-many self referencing relationships

  #89 closed Aug 14, 2025

• How to deal with column type needed situation?

  #95 closed Aug 13, 2025

• Return a Column class for relationship attributes that require it

  #107 closed Aug 13, 2025

• Proper handling of None in WHERE condition

  #109 closed Aug 13, 2025

• "Can't generate DDL for NullType()" when using pydantic.SecretStr

  #112 closed Aug 13, 2025

• Generatate composite unique constraints

  #114 closed Aug 13, 2025

• not autocompletion

  #1080 closed Aug 13, 2025

• Grouped result of multiple joins

  #118 closed Aug 13, 2025

• Are Many-to-Many link supported with fastapi?

  #121 closed Aug 13, 2025

• engine singleton Built in SQLmodel or make my own ?

  #123 closed Aug 13, 2025

• Simple instructions for a self referential table

  #127 closed Aug 13, 2025

• Error when using Relationships with one-to-one models

  #132 closed Aug 13, 2025

• proper SQLmodel approach for Many to Many subqueryLoad

  #135 closed Aug 13, 2025

• How PostgreSQL sequence can be mapped with a column using SqlModel?

  #137 closed Aug 12, 2025

• [fastAPI/Gunicorn]: psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "pg_type_typname_nsp_index"

  #138 closed Aug 12, 2025

• equivalent for .subquery('t2') sqlalchemy

  #139 closed Aug 12, 2025

• Establish relationship using Relationship feature in Postgres

  #141 closed Aug 12, 2025

• Using both SQL-Alchemy Base declarative and SQL Model

  #169 closed Aug 12, 2025

• How to use the method tablesample

  #172 closed Aug 12, 2025

• How to accomplish Read/Write transactions with a one to many relationship

  #176 closed Aug 12, 2025

• Flowing large hash values to Postgres BigInt

  #191 closed Aug 12, 2025

• Is it possible to update schema once created?

  #204 closed Aug 12, 2025

• Pylance / VSCode cannot find sqlmodel typings correctly

  #208 closed Aug 12, 2025

• sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'Color'

  #212 closed Aug 12, 2025

• BUG: Background Task Cannot Get Database Updates

  #220 closed Aug 12, 2025

• Map attributes from link model(association table)

  #226 closed Aug 12, 2025

• Sharing class registry from declarative base to SQLModel to enable relationships

  #245 closed Aug 12, 2025

• Accessing and displaying the Field description attribute

  #246 closed Aug 12, 2025

• Access Relationship (from table model) from Read Model

  #250 closed Aug 12, 2025

• Is there a way to use attributes on a relationship attribute when selecting models using `where`?

  #261 closed Aug 12, 2025

• Mypy errors: Incompatible type for optional ids & Incompatible type for SQLModel attribute in expression

  #267 closed Aug 12, 2025

• Is there a way to get a random record and/or order a query randomly with SQLmodel?

  #277 closed Aug 12, 2025

• Enums are not autocompleted & gives error

  #278 closed Aug 12, 2025

• How to get row count of session.exec result

  #280 closed Aug 11, 2025

• Return type of item id from session.exec is `int | None`. How can I make it `int`.

  #282 closed Aug 11, 2025

• Unable to get a nested (join) response on 1:1 relationship

  #284 closed Aug 11, 2025

• How to use Pickle Type

  #285 closed Aug 11, 2025

• How to add BIT(1) data type to field?

  #298 closed Aug 11, 2025

• TypeError: issubclass() arg 1 must be a class

  #312 closed Aug 11, 2025

• How to Initialise & Populate a Postgres Database with Circular ForeignKeys?

  #313 closed Aug 11, 2025

• no such table, SQLModel can't find the table

  #318 closed Aug 11, 2025

• Specifying SQL Server column data type, similar to dtype in pd.to_sql()

  #319 closed Aug 11, 2025

• sa_column(ForeignKey) not working

  #326 closed Aug 11, 2025

• AttributeError: 'XXXXX' object has no attribute 'YYYYY' only in aws lambda function

  #332 closed Aug 11, 2025

• Choose which model to consider

  #291 closed Aug 11, 2025

• Intellisense autocomplete does not show for `in_` in VSCode

  #294 closed Aug 11, 2025

• How to translate query lookup string into a SQLModel object?

  #343 closed Aug 11, 2025

• SQLModel class cannot be extended with non-Pydantic bases

  #348 closed Aug 11, 2025

• How to use the "IN" clause using the select statement

  #353 closed Aug 11, 2025

• Optional ID value for auto-increment causes type errors when retrieving from database

  #365 closed Aug 11, 2025

1 Issue opened by 1 person

• `Field(alias="")` doesn't work with Pydantic V2

  #1536 opened Aug 26, 2025

62 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• 🐛 Fix `TypeError` for fields annotated with `Literal`

  #1439 commented on Sep 2, 2025 • 12 new comments

• Tests and example for how to use relationship alias.

  #815 commented on Sep 8, 2025 • 12 new comments

• 📝 Add code example for `sa_column` `onupdate` timestamps

  #372 commented on Aug 25, 2025 • 9 new comments

• ✨ Add IntEnum for sqltypes

  #1337 commented on Aug 25, 2025 • 7 new comments

• 📝 Add docs page for self-referential model

  #408 commented on Aug 28, 2025 • 4 new comments

• ✨ Add support for pydantic date types

  #1384 commented on Aug 23, 2025 • 3 new comments

• 🏷️ Adjust type annotation for `Field.sa_type` to support instantiated SQLAlchemy types

  #1345 commented on Sep 2, 2025 • 2 new comments

• ♻️ Use mysql's default string length for mariadb

  #882 commented on Sep 8, 2025 • 2 new comments

• 🐛 Fix `RuntimeError: dictionary changed size during iteration` in `sqlmodel_update()`

  #997 commented on Aug 21, 2025 • 2 new comments

• support optional annotated field with default value

  #862 commented on Aug 22, 2025 • 1 new comment

• ✨Properly support inheritance of Relationship attributes

  #886 commented on Sep 2, 2025 • 1 new comment

• ✨Add `sa_foreign_key_args` and `sa_foreign_key_kwargs` arguments to `Field`...

  #894 commented on Sep 2, 2025 • 1 new comment

• Added typecheck to sqlalchemy JSON

  #931 commented on Sep 8, 2025 • 1 new comment

• ✨ `Field()` supports `json_schema_extra` for Pydantic v2

  #1035 commented on Aug 23, 2025 • 1 new comment

• 🐛 Ensure that type checks are executed when setting `table=True`

  #1041 commented on Sep 2, 2025 • 1 new comment

• Support hybrid_property, column_property, declared_attr

  #801 commented on Sep 5, 2025 • 0 new comments

• Possibility to change default Pydantic to SQLAlchemy mappings

  #800 commented on Sep 5, 2025 • 0 new comments

• Add type of _TScalar at expression.py.jinja2

  #776 commented on Sep 9, 2025 • 0 new comments

• Document using SQLAlchemy column types; add pydantic.EmailStr support

  #762 commented on Sep 5, 2025 • 0 new comments

• Alembic integration and documentation

  #689 commented on Sep 5, 2025 • 0 new comments

• update async extension and add tests

  #635 commented on Sep 5, 2025 • 0 new comments

• Added Documentation for usage with async tools. Fixes #626

  #633 commented on Sep 5, 2025 • 0 new comments

• Add an AwaitableField for accessing sqlmodel field asynchronously

  #872 commented on Sep 5, 2025 • 0 new comments

• ✨ Add support for safe access to PK int autotypes

  #999 commented on Aug 22, 2025 • 0 new comments

• ✨ Support sqlalchemy `MappedColumn`

  #1143 commented on Aug 25, 2025 • 0 new comments

• ✨ Allow to use Enums in custom DB schema

  #1146 commented on Aug 23, 2025 • 0 new comments

• ✨ Add PEP 593 support for Requirement annotations

  #1192 commented on Aug 25, 2025 • 0 new comments

• ✨ Add support for SQLAlchemy polymorphic models

  #1226 commented on Aug 28, 2025 • 0 new comments

• 💥 Rename `regex` to `pattern` to provide compatibility with Pydantic V2

  #1231 commented on Aug 30, 2025 • 0 new comments

• ✨ Support merging `FieldInfo` values from multiple `Field` objects

  #1281 commented on Sep 5, 2025 • 0 new comments

• ✨ Add overload for `exec` method to support `insert`, `update`, `delete` statements

  #1342 commented on Aug 15, 2025 • 0 new comments

• ⬆ Bump mypy from 1.4.1 to 1.17.1

  #1449 commented on Sep 5, 2025 • 0 new comments

• How to set check constraint in sql model?

  #292 commented on Aug 11, 2025 • 0 new comments

• Add support for deferred column loading

  #97 commented on Aug 13, 2025 • 0 new comments

• Getting field metadata for use in autogenerated model diagrams (erdantic)

  #102 commented on Aug 14, 2025 • 0 new comments

• How to access a parent model's relationship's attributes

  #77 commented on Aug 14, 2025 • 0 new comments

• Can SQLModel be more generic in its implementations? Swappable backends?

  #61 commented on Aug 15, 2025 • 0 new comments

• Add an overload to the `exec` method with `_Executable` statement for update and delete statements

  #909 commented on Aug 15, 2025 • 0 new comments

• Advanced Tutorial - Documentation

  #161 commented on Aug 23, 2025 • 0 new comments

• open ended discussion: use of PEP 593 in the "model" ecosystem

  #229 commented on Aug 25, 2025 • 0 new comments

• Delete cascade not working in AsyncSession

  #480 commented on Aug 26, 2025 • 0 new comments

• PySQLX-Engine with async core

  #402 commented on Aug 26, 2025 • 0 new comments

• Flexibly Create Nested Database Entries from Incoming Pydantic/SQLModels

  #6 commented on Aug 26, 2025 • 0 new comments

• JSON Fields for Nested Pydantic Models?

  #63 commented on Aug 26, 2025 • 0 new comments

• Field(allow_mutation=False) doesn't have same behavior as pydantic

  #262 commented on Aug 27, 2025 • 0 new comments

• How to mix untyped and typed models?

  #200 commented on Aug 27, 2025 • 0 new comments

• How to define unique constraint in table columns

  #82 commented on Aug 27, 2025 • 0 new comments

• Dose there any better way to write timezone aware datetime field without using the SQLAlchemy ?

  #539 commented on Aug 29, 2025 • 0 new comments

• _sa_instance_state is dropped when SQLModels are nested. Is this expected?

  #375 commented on Aug 31, 2025 • 0 new comments

• Why does a SQLModel class with `table=True` not validate data ?

  #453 commented on Sep 2, 2025 • 0 new comments

• Pyright cannot recognize the type of `SQLModel.__tablename__`

  #98 commented on Sep 3, 2025 • 0 new comments

• ✨ Add dynamic model creation

  #43 commented on Sep 5, 2025 • 0 new comments

• Class Initialisation Validation Kwarg

  #227 commented on Sep 5, 2025 • 0 new comments

• 🐛 Support mixins

  #256 commented on Sep 5, 2025 • 0 new comments

• Added asynchronous support

  #435 commented on Sep 5, 2025 • 0 new comments

• Add config option to load relationship fields.

  #445 commented on Aug 25, 2025 • 0 new comments

• Examples and tests for async support in `SQLModel`

  #471 commented on Sep 5, 2025 • 0 new comments

• Adding _init_private_attributes to SQLModel __init__ function.

  #472 commented on Sep 8, 2025 • 0 new comments

• ✨ Add support for hybrid_property

  #482 commented on Sep 8, 2025 • 0 new comments

• 👷 Add codespell workflow + fix some typos

  #588 commented on Aug 25, 2025 • 0 new comments

• Add kwargs to ForeignKey definitions

  #610 commented on Sep 5, 2025 • 0 new comments

• 📝 Document `.in_()` method

  #619 commented on Aug 23, 2025 • 0 new comments