Method _bind_param

lib/sqlalchemy/sql/elements.py:4087–4115

For new style any_(), all_(), ensure compared literal value receives appropriate bound parameter type.

(
        self,
        operator: operators.OperatorType,
        obj: Any,
        type_: Optional[TypeEngine[_T]] = None,
        expanding: bool = False,
    )

    @util.preload_module("sqlalchemy.sql.sqltypes")
    def _bind_param(
        self,
        operator: operators.OperatorType,
        obj: Any,
        type_: Optional[TypeEngine[_T]] = None,
        expanding: bool = False,
    ) -> BindParameter[_T]:
        """For new style any_(), all_(), ensure compared literal value
        receives appropriate bound parameter type."""

        # a CollectionAggregate is specific to ARRAY or int
        # only.  So for ARRAY case, make sure we use correct element type
        sqltypes = util.preloaded.sql_sqltypes
        if self.element.type._type_affinity is sqltypes.ARRAY:
            compared_to_type = cast(
                sqltypes.ARRAY[Any], self.element.type
            ).item_type
        else:
            compared_to_type = self.element.type

        return BindParameter(
            None,
            obj,
            _compared_to_operator=operator,
            type_=type_,
            _compared_to_type=compared_to_type,
            unique=True,
            expanding=expanding,
        )

    # operate and reverse_operate are hardwired to
    # dispatch onto the type comparator directly, so that we can