Method alias

lib/sqlalchemy/sql/selectable.py:2273–2297

Return an :class:`_expression.Alias` of this :class:`_expression.CTE`. This method is a CTE-specific specialization of the :meth:`_expression.FromClause.alias` method. .. seealso:: :ref:`tutorial_using_aliases` :func:`_expression.alias`

(
        self, name: Optional[str] = None, flat: bool = False
    )

            )

    def alias(
        self, name: Optional[str] = None, flat: bool = False
    ) -> CTE[_KeyColCC_co]:
        """Return an :class:`_expression.Alias` of this
        :class:`_expression.CTE`.

        This method is a CTE-specific specialization of the
        :meth:`_expression.FromClause.alias` method.

        .. seealso::

            :ref:`tutorial_using_aliases`

            :func:`_expression.alias`

        """
        return CTE._construct(
            self.element,
            name=name,
            recursive=self.recursive,
            nesting=self.nesting,
            _cte_alias=self,
            _prefixes=self._prefixes,
            _suffixes=self._suffixes,
        )

    def union(
        self, *other: _SelectStatementForCompoundArgument[Any]