Method where

sqlmodel/sql/_expression_select_cls.py:19–23

Return a new `Select` construct with the given expression added to its `WHERE` clause, joined to the existing clause via `AND`, if any.

(self, *whereclause: _ColumnExpressionArgument[bool] | bool)

    inherit_cache = True

    def where(self, *whereclause: _ColumnExpressionArgument[bool] | bool) -> Self:
        """Return a new `Select` construct with the given expression added to
        its `WHERE` clause, joined to the existing clause via `AND`, if any.
        """
        return super().where(*whereclause)  # ty: ignore[invalid-argument-type]

    def having(self, *having: _ColumnExpressionArgument[bool] | bool) -> Self:
        """Return a new `Select` construct with the given expression added to