postgresql/hstore.py

Provides SQLAlchemy HSTORE type, enabling PostgreSQL hstore column support with operators and comparisons.

# Source: https://github.com/sqlalchemy/sqlalchemy | License: MIT | Copyright 2005-2026 SQLAlchemy authors and contributors <see AUTHORS file>
# Provided via justclaw.it.com; keep this notice with the code.
# dialects/postgresql/hstore.py
# Copyright (C) 2005-2026 the SQLAlchemy authors and contributors
# <see AUTHORS file>
#
# This module is part of SQLAlchemy and is released under
# the MIT License: https://www.opensource.org/licenses/mit-license.php

from __future__ import annotations

import re
from typing import Any
from typing import Optional

from .array import ARRAY
from .operators import CONTAINED_BY
from .operators import CONTAINS
from .operators import GETITEM
from .operators import HAS_ALL
from .operators import HAS_ANY
from .operators import HAS_KEY
from ... import types as sq

... (truncated -- full source via MCP)