Method over

lib/sqlalchemy/sql/elements.py:4958–4993

Produce an OVER clause against this filtered function. Used against aggregate or so-called "window" functions, for database backends that support window functions. The expression:: func.rank().filter(MyClass.y > 5).over(order_by="x") is shorthand for::

(
        self,
        partition_by: _ByArgument | None = None,
        order_by: _ByArgument | None = None,
        range_: _FrameIntTuple | FrameClause | None = None,
        rows: _FrameIntTuple | FrameClause | None = None,
        groups: _FrameIntTuple | FrameClause | None = None,
        exclude: str | None = None,
    )

        return self

    def over(
        self,
        partition_by: _ByArgument | None = None,
        order_by: _ByArgument | None = None,
        range_: _FrameIntTuple | FrameClause | None = None,
        rows: _FrameIntTuple | FrameClause | None = None,
        groups: _FrameIntTuple | FrameClause | None = None,
        exclude: str | None = None,
    ) -> Over[_T]:
        """Produce an OVER clause against this filtered function.

        Used against aggregate or so-called "window" functions,
        for database backends that support window functions.

        The expression::

            func.rank().filter(MyClass.y > 5).over(order_by="x")

        is shorthand for::

            from sqlalchemy import over, funcfilter

            over(funcfilter(func.rank(), MyClass.y > 5), order_by="x")

        See :func:`_expression.over` for a full description.

        """
        return Over(
            self,
            partition_by=partition_by,
            order_by=order_by,
            range_=range_,
            rows=rows,
            groups=groups,
            exclude=exclude,
        )

    def within_group(
        self, *order_by: _ColumnExpressionArgument[Any]