Function asc

lib/sqlalchemy/sql/_elements_constructors.py:312–352

Produce an ascending ``ORDER BY`` clause element. e.g.:: from sqlalchemy import asc stmt = select(users_table).order_by(asc(users_table.c.name)) will produce SQL as: .. sourcecode:: sql SELECT id, name FROM user ORDER BY name ASC The :func:`.asc` functi

(
    column: _ColumnExpressionOrStrLabelArgument[_T],
)

def asc(
    column: _ColumnExpressionOrStrLabelArgument[_T],
) -> UnaryExpression[_T]:
    """Produce an ascending ``ORDER BY`` clause element.

    e.g.::

        from sqlalchemy import asc

        stmt = select(users_table).order_by(asc(users_table.c.name))

    will produce SQL as:

    .. sourcecode:: sql

        SELECT id, name FROM user ORDER BY name ASC

    The :func:`.asc` function is a standalone version of the
    :meth:`_expression.ColumnElement.asc`
    method available on all SQL expressions,
    e.g.::


        stmt = select(users_table).order_by(users_table.c.name.asc())

    :param column: A :class:`_expression.ColumnElement` (e.g.
     scalar SQL expression)
     with which to apply the :func:`.asc` operation.

    .. seealso::

        :func:`.desc`

        :func:`.nulls_first`

        :func:`.nulls_last`

        :meth:`_expression.Select.order_by`

    """
    return UnaryExpression._create_asc(column)


def collate(