]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
allow JSON, JSONB, etc. to be parameterized, type HSTORE
authorMike Bayer <mike_mp@zzzcomputing.com>
Wed, 18 Feb 2026 15:12:52 +0000 (10:12 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 6 Mar 2026 19:25:03 +0000 (14:25 -0500)
commitb88d9e0969129dfc3efd5bcad617bd4872e6ea9c
treea8050c9f301c93541a112bccd01c00675e53d159
parentd7ade42828457f7f6b76ecce8f17b1aa597c54ec
allow JSON, JSONB, etc. to be parameterized, type HSTORE

Improved typing of :class:`_sqltypes.JSON` as well as dialect specific
variants like :class:`_postgresql.JSON` to include generic capabilities, so
that the types may be parameterized to indicate any specific type of
contents expected, e.g. ``JSONB[list[str]]()``.

Also types HSTORE

Fixes: #13131
Change-Id: Ia089ba4e3cebf6339a5420b2923cd267c4e6891a
15 files changed:
doc/build/changelog/unreleased_21/13131.rst [new file with mode: 0644]
lib/sqlalchemy/__init__.py
lib/sqlalchemy/dialects/mssql/json.py
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/mysql/json.py
lib/sqlalchemy/dialects/postgresql/hstore.py
lib/sqlalchemy/dialects/postgresql/json.py
lib/sqlalchemy/dialects/sqlite/json.py
lib/sqlalchemy/sql/__init__.py
lib/sqlalchemy/sql/expression.py
lib/sqlalchemy/sql/sqltypes.py
lib/sqlalchemy/util/typing.py
test/typing/plain_files/dialects/mysql/mysql_stuff.py
test/typing/plain_files/dialects/postgresql/pg_stuff.py
test/typing/plain_files/sql/sqltypes.py