sqlalchemy.sql.selectable

module documentation
(source)

The :class:`_expression.FromClause` class of SQL expression elements, representing SQL tables and derived rowsets.

Class Alias Represents an table or selectable alias (AS).
Class AliasedReturnsRows Base class of aliases against tables, subqueries, and other selectables.
Class AnnotatedFromClause No class docstring; 1/1 property, 0/1 method documented
Class CompoundSelect Forms the basis of ``UNION``, ``UNION ALL``, and other SELECT-based set operations.
Class CompoundSelectState Undocumented
Class CTE Represent a Common Table Expression.
Class ExecutableReturnsRows base for executable statements that return rows.
Class Exists Represent an ``EXISTS`` clause.
Class ForUpdateArg No class docstring; 0/5 instance variable, 0/1 class variable, 1/4 method, 0/1 class method documented
Class FromClause Represent an element that can be used within the ``FROM`` clause of a ``SELECT`` statement.
Class FromClauseAlias Undocumented
Class FromGrouping Represent a grouping of a FROM clause
Class GenerativeSelect Base class for SELECT statements where additional elements can be added.
Class HasCTE Mixin that declares a class to include CTE support.
Class HasHints No class docstring; 0/3 class variable, 2/3 methods documented
Class HasPrefixes No class docstring; 0/1 instance variable, 0/1 class variable, 1/1 method documented
Class HasSuffixes No class docstring; 0/1 instance variable, 0/1 class variable, 1/1 method documented
Class Join Represent a ``JOIN`` construct between two :class:`_expression.FromClause` elements.
Class Lateral Represent a LATERAL subquery.
Class LateralFromClause mark a FROM clause as being able to render directly as LATERAL
Class NamedFromClause A :class:`.FromClause` that has a name.
Class NamedFromGrouping represent a grouping of a named FROM clause
Class NoInit Undocumented
Class ReturnsRows The base-most class for Core constructs that have some concept of columns that can represent rows.
Class ScalarSelect Represent a scalar subquery.
Class ScalarValues Represent a scalar ``VALUES`` construct that can be used as a COLUMN element in a statement.
Class Select Represents a ``SELECT`` statement.
Class Selectable Mark a class as being selectable.
Class SelectBase Base class for SELECT statements.
Class SelectLabelStyle Label style constants that may be passed to :meth:`_sql.Select.set_label_style`.
Class SelectsRows Sub-base of ReturnsRows for elements that deliver rows directly, namely SELECT and INSERT/UPDATE/DELETE..RETURNING
Class SelectState No class docstring; 0/5 instance variable, 0/2 class variable, 2/7 methods, 1/9 class method documented
Class SelectStatementGrouping Represent a grouping of a :class:`_expression.SelectBase`.
Class Subquery Represent a subquery of a SELECT.
Class TableClause Represents a minimal "table" construct.
Class TableSample Represent a TABLESAMPLE clause.
Class TableValuedAlias An alias against a "table valued" SQL function.
Class TextualSelect Wrap a :class:`_expression.TextClause` construct within a :class:`_expression.SelectBase` interface.
Class TypedReturnsRows base for executable statements that return rows.
Class Values Represent a ``VALUES`` construct that can be used as a FROM element in a statement.
Constant LABEL_STYLE_DISAMBIGUATE_ONLY Undocumented
Constant LABEL_STYLE_NONE Undocumented
Constant LABEL_STYLE_TABLENAME_PLUS_COL Undocumented
Class _ColumnsPlusNames No class docstring; 5/5 class variables documented
Class _CompoundSelectKeyword Undocumented
Class _CTEOpts Undocumented
Class _JoinTargetProtocol Undocumented
Class _MemoizedSelectEntities represents partial state from a Select object, for the case where Select.columns() has redefined the set of columns/entities the statement will be SELECTing from. This object represents the entities from the SELECT before that transformation was applied, so that transformations that were made in terms of the SELECT at that time, such as join() as well as options(), can access the correct context.
Class _OffsetLimitParam Undocumented
Class _SelectFromElements Undocumented
Type Variable _SB Undocumented
Type Variable _T Undocumented
Type Alias _ColumnsClauseElement Undocumented
Type Alias _ForUpdateOfArgument Undocumented
Type Alias _JoinTargetElement Undocumented
Type Alias _LabelConventionCallable Undocumented
Type Alias _OnClauseElement Undocumented
Type Alias _SelectIterable Undocumented
Type Alias _SetupJoinsElement Undocumented
Variable _ Undocumented
LABEL_STYLE_DISAMBIGUATE_ONLY = (source)

Undocumented

LABEL_STYLE_NONE = (source)

Undocumented

LABEL_STYLE_TABLENAME_PLUS_COL = (source)

Undocumented

_SB = (source)

Undocumented

Value
TypeVar('_SB',
        bound=SelectBase)
_T = (source)

Undocumented

Value
TypeVar('_T',
        bound=Any)
_ColumnsClauseElement = (source)

Undocumented

Value
Union['FromClause', ColumnElement[Any], 'TextClause']
_ForUpdateOfArgument = (source)

Undocumented

Value
Union[Union['_ColumnExpressionArgument[Any]', '_FromClauseArgument'],
      Sequence['_ColumnExpressionArgument[Any]']]
_JoinTargetElement = (source)

Undocumented

Value
Union['FromClause', _JoinTargetProtocol]
_LabelConventionCallable = (source)

Undocumented

Value
Callable[[Union['ColumnElement[Any]', 'TextClause']], Optional[str]]
_OnClauseElement = (source)

Undocumented

Value
Union['ColumnElement[bool]', _JoinTargetProtocol]
_SelectIterable = (source)

Undocumented

Value
Iterable[Union['ColumnElement[Any]', 'TextClause']]
_SetupJoinsElement = (source)

Undocumented

Value
Tuple[_JoinTargetElement,
      Optional[_OnClauseElement],
      Optional['FromClause'],
      Dict[str, Any]]
_ = (source)

Undocumented