Sqlmodel

Features

* ✨ Add new method `.sqlmodel_update()` to update models in place, including an `update` parameter for extra data. And fix implementation for the (now documented) `update` parameter for `.model_validate()`. PR [804](https://github.com/tiangolo/sqlmodel/pull/804) by [tiangolo](https://github.com/tiangolo).
* Updated docs: [Update Data with FastAPI](https://sqlmodel.tiangolo.com/tutorial/fastapi/update/).
* New docs: [Update with Extra Data (Hashed Passwords) with FastAPI](https://sqlmodel.tiangolo.com/tutorial/fastapi/update-extra-data/).

Fixes

* 🐛 Fix class initialization compatibility with Pydantic and SQLModel, fixing errors revealed by the latest Pydantic. PR [807](https://github.com/tiangolo/sqlmodel/pull/807) by [tiangolo](https://github.com/tiangolo).

Internal

* ⬆ Bump tiangolo/issue-manager from 0.4.0 to 0.4.1. PR [775](https://github.com/tiangolo/sqlmodel/pull/775) by [dependabot[bot]](https://github.com/apps/dependabot).
* 👷 Fix GitHub Actions build docs filter paths for GitHub workflows. PR [738](https://github.com/tiangolo/sqlmodel/pull/738) by [tiangolo](https://github.com/tiangolo).

Features

* ✨ Add support for Pydantic v2 (while keeping support for v1 if v2 is not available). PR [722](https://github.com/tiangolo/sqlmodel/pull/722) by [tiangolo](https://github.com/tiangolo) including initial work in PR [#699](https://github.com/tiangolo/sqlmodel/pull/699) by [AntonDeMeester](https://github.com/AntonDeMeester).

Fixes

* ♻️ Refactor type generation of selects re-order to prioritize models to optimize editor support. PR [718](https://github.com/tiangolo/sqlmodel/pull/718) by [tiangolo](https://github.com/tiangolo).

Refactors

* 🔇 Do not raise deprecation warnings for execute as it's automatically used internally. PR [716](https://github.com/tiangolo/sqlmodel/pull/716) by [tiangolo](https://github.com/tiangolo).
* ✅ Move OpenAPI tests inline to simplify updating them with Pydantic v2. PR [709](https://github.com/tiangolo/sqlmodel/pull/709) by [tiangolo](https://github.com/tiangolo).

Upgrades

* ⬆️ Add support for Python 3.11 and Python 3.12. PR [710](https://github.com/tiangolo/sqlmodel/pull/710) by [tiangolo](https://github.com/tiangolo).

Docs

* ✏️ Fix typo, simplify single quote/apostrophe character in "Sister Margaret's" everywhere in the docs. PR [721](https://github.com/tiangolo/sqlmodel/pull/721) by [tiangolo](https://github.com/tiangolo).
* 📝 Update docs for Decimal, use proper types. PR [719](https://github.com/tiangolo/sqlmodel/pull/719) by [tiangolo](https://github.com/tiangolo).
* 📝 Add source examples for Python 3.9 and 3.10. PR [715](https://github.com/tiangolo/sqlmodel/pull/715) by [tiangolo](https://github.com/tiangolo).

Internal

* 🙈 Update gitignore, include all coverage files. PR [711](https://github.com/tiangolo/sqlmodel/pull/711) by [tiangolo](https://github.com/tiangolo).
* 🔧 Update config with new pymdown extensions. PR [712](https://github.com/tiangolo/sqlmodel/pull/712) by [tiangolo](https://github.com/tiangolo).
* 🔧 Update docs build setup, add support for sponsors, add sponsor GOVCERT.LU. PR [720](https://github.com/tiangolo/sqlmodel/pull/720) by [tiangolo](https://github.com/tiangolo).
* ⬆ [pre-commit.ci] pre-commit autoupdate. PR [697](https://github.com/tiangolo/sqlmodel/pull/697) by [pre-commit-ci[bot]](https://github.com/apps/pre-commit-ci).
* 🔧 Show line numbers in docs during local development. PR [714](https://github.com/tiangolo/sqlmodel/pull/714) by [tiangolo](https://github.com/tiangolo).
* 📝 Update details syntax with new pymdown extensions format. PR [713](https://github.com/tiangolo/sqlmodel/pull/713) by [tiangolo](https://github.com/tiangolo).

Features

* ✨ Upgrade SQLAlchemy to 2.0. PR [700](https://github.com/tiangolo/sqlmodel/pull/700) by [tiangolo](https://github.com/tiangolo) including initial work in PR [#563](https://github.com/tiangolo/sqlmodel/pull/563) by [farahats9](https://github.com/farahats9).

Internal

* ⬆ [pre-commit.ci] pre-commit autoupdate. PR [686](https://github.com/tiangolo/sqlmodel/pull/686) by [pre-commit-ci[bot]](https://github.com/apps/pre-commit-ci).
* 👷 Upgrade latest-changes GitHub Action. PR [693](https://github.com/tiangolo/sqlmodel/pull/693) by [tiangolo](https://github.com/tiangolo).

Features

* ✨ Add support for passing a custom SQLAlchemy type to `Field()` with `sa_type`. PR [505](https://github.com/tiangolo/sqlmodel/pull/505) by [maru0123-2004](https://github.com/maru0123-2004).
* You might consider this a breaking change if you were using an incompatible combination of arguments, those arguments were not taking effect and now you will have a type error and runtime error telling you that.
* ✨ Do not allow invalid combinations of field parameters for columns and relationships, `sa_column` excludes `sa_column_args`, `primary_key`, `nullable`, etc. PR [681](https://github.com/tiangolo/sqlmodel/pull/681) by [tiangolo](https://github.com/tiangolo).

Docs

* 🎨 Update inline source examples, hide `` in annotations (from MkDocs Material). PR [677](https://github.com/tiangolo/sqlmodel/pull/677) by [Matthieu-LAURENT39](https://github.com/Matthieu-LAURENT39).

Internal

* ⬆ Update coverage requirement from ^6.2 to >=6.2,<8.0. PR [663](https://github.com/tiangolo/sqlmodel/pull/663) by [dependabot[bot]](https://github.com/apps/dependabot).
* ⬆ Update mkdocs-material requirement from 9.1.21 to 9.2.7. PR [675](https://github.com/tiangolo/sqlmodel/pull/675) by [dependabot[bot]](https://github.com/apps/dependabot).
* ⬆️ Upgrade mypy manually. PR [684](https://github.com/tiangolo/sqlmodel/pull/684) by [tiangolo](https://github.com/tiangolo).
* ⬆ Update black requirement from ^22.10.0 to >=22.10,<24.0. PR [664](https://github.com/tiangolo/sqlmodel/pull/664) by [dependabot[bot]](https://github.com/apps/dependabot).
* 👷 Update CI to build MkDocs Insiders only when the secrets are available, for Dependabot. PR [683](https://github.com/tiangolo/sqlmodel/pull/683) by [tiangolo](https://github.com/tiangolo).