sqlalchemy.sql.selectable.HasSuffixes

class documentation

class HasSuffixes: (source)

Known subclasses: sqlalchemy.orm.query.Query, sqlalchemy.sql.selectable.CTE, sqlalchemy.sql.selectable.Select

Undocumented

Method	`suffix_with`	Add one or more expressions following the statement as a whole.
Class Variable	`_has_suffixes_traverse_internals`	Undocumented
Instance Variable	`_suffixes`	Undocumented

@_generative
@_document_text_coercion('suffixes', ':meth:`_expression.HasSuffixes.suffix_with`', ':paramref:`.HasSuffixes.suffix_with.*suffixes`')
def suffix_with(self, *suffixes: _TextCoercedExpressionArgument[Any], dialect: str = '*') -> Self: (source) ¶

Add one or more expressions following the statement as a whole. This is used to support backend-specific suffix keywords on certain constructs. E.g.:: stmt = select(col1, col2).cte().suffix_with( "cycle empno set y_cycle to 1 default 0", dialect="oracle") Multiple suffixes can be specified by multiple calls to :meth:`_expression.HasSuffixes.suffix_with`. :param \*suffixes: textual or :class:`_expression.ClauseElement` construct which will be rendered following the target clause. :param dialect: Optional string dialect name which will limit rendering of this suffix to only that dialect.

_has_suffixes_traverse_internals: _TraverseInternalsType = (source) ¶

Undocumented

_suffixes = (source) ¶

overridden in sqlalchemy.sql.selectable.CTE

Undocumented