Method ext

lib/sqlalchemy/orm/query.py:2727–2744

Applies a SQL syntax extension to this statement. .. seealso:: :ref:`examples_syntax_extensions` :func:`_mysql.limit` - DML LIMIT for MySQL :func:`_postgresql.distinct_on` - DISTINCT ON for PostgreSQL .. versionadded:: 2.1

(self, extension: SyntaxExtension)

    @_generative
    def ext(self, extension: SyntaxExtension) -> Self:
        """Applies a SQL syntax extension to this statement.

        .. seealso::

            :ref:`examples_syntax_extensions`

            :func:`_mysql.limit` - DML LIMIT for MySQL

            :func:`_postgresql.distinct_on` - DISTINCT ON for PostgreSQL

        .. versionadded:: 2.1

        """

        extension = coercions.expect(roles.SyntaxExtensionRole, extension)
        self._syntax_extensions += (extension,)
        return self

    def all(self) -> List[_T]:
        """Return the results represented by this :class:`_query.Query`