Function collate

lib/sqlalchemy/sql/_elements_constructors.py:368–392

Return the clause ``expression COLLATE collation``. e.g.:: collate(mycolumn, "utf8_bin") produces: .. sourcecode:: sql mycolumn COLLATE utf8_bin The collation expression is also quoted if it is a case sensitive identifier, e.g. contains uppercase characters.

(
    expression: _ColumnExpressionArgument[str], collation: str
)

def collate(
    expression: _ColumnExpressionArgument[str], collation: str
) -> BinaryExpression[str]:
    """Return the clause ``expression COLLATE collation``.

    e.g.::

        collate(mycolumn, "utf8_bin")

    produces:

    .. sourcecode:: sql

        mycolumn COLLATE utf8_bin

    The collation expression is also quoted if it is a case sensitive
    identifier, e.g. contains uppercase characters.

    """
    if isinstance(expression, operators.ColumnOperators):
        return expression.collate(collation)  # type: ignore
    else:
        return CollationClause._create_collation_expression(
            expression, collation
        )


def between(