class TextualSelect(SelectBase, ExecutableReturnsRows, Generative): (source)
Wrap a :class:`_expression.TextClause` construct within a :class:`_expression.SelectBase` interface. This allows the :class:`_expression.TextClause` object to gain a ``.c`` collection and other FROM-like capabilities such as :meth:`_expression.FromClause.alias`, :meth:`_expression.SelectBase.cte`, etc. The :class:`_expression.TextualSelect` construct is produced via the :meth:`_expression.TextClause.columns` method - see that method for details. .. versionchanged:: 1.4 the :class:`_expression.TextualSelect` class was renamed from ``TextAsFrom``, to more correctly suit its role as a SELECT-oriented object and not a FROM clause. .. seealso:: :func:`_expression.text` :meth:`_expression.TextClause.columns` - primary creation interface.
Method | __init__ |
Undocumented |
Method | bindparams |
Undocumented |
Method | selected |
A :class:`_expression.ColumnCollection` representing the columns that this SELECT statement or similar construct returns in its result set, not including :class:`_sql.TextClause` constructs. |
Method | set |
Return a new selectable with the specified label style. |
Class Variable | __visit |
Undocumented |
Class Variable | is |
Undocumented |
Class Variable | is |
Undocumented |
Instance Variable | column |
Undocumented |
Instance Variable | element |
Undocumented |
Instance Variable | positional |
Undocumented |
Method | _ensure |
Ensure that the names generated by this selectbase will be disambiguated in some way, if possible. |
Method | _generate |
Populate columns into an :class:`.AliasedReturnsRows` object. |
Method | _init |
Undocumented |
Method | _scalar |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _traverse |
Undocumented |
Property | _all |
A sequence of expressions that correspond to what is rendered in the columns clause, including :class:`_sql.TextClause` constructs. |
Inherited from SelectBase
:
Method | alias |
Return a named subquery against this :class:`_expression.SelectBase`. |
Method | as |
Undocumented |
Method | exists |
Return an :class:`_sql.Exists` representation of this selectable, which can be used as a column expression. |
Method | get |
Retrieve the current label style. |
Method | label |
Return a 'scalar' representation of this selectable, embedded as a subquery with a label. |
Method | lateral |
Return a LATERAL alias of this :class:`_expression.Selectable`. |
Method | scalar |
Return a 'scalar' representation of this selectable, which can be used as a column expression. |
Method | select |
Undocumented |
Method | subquery |
Return a subquery of this :class:`_expression.SelectBase`. |
Property | c |
Undocumented |
Property | columns |
Undocumented |
Property | exported |
A :class:`_expression.ColumnCollection` that represents the "exported" columns of this :class:`_expression.Selectable`, not including :class:`_sql.TextClause` constructs. |
Method | _implicit |
Undocumented |
Method | _refresh |
reset internal collections for an incoming column being added. |
Class Variable | _is |
Undocumented |
Inherited from SelectStatementRole
(via SelectBase
):
Class Variable | __slots__ |
Undocumented |
Class Variable | _role |
Undocumented |
Inherited from Executable
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
):
Method | execution |
Set non-SQL options for the statement which take effect during execution. |
Method | get |
Get the non-SQL options which will take effect during execution. |
Method | options |
Apply options to this statement. |
Class Variable | is |
Undocumented |
Class Variable | is |
Undocumented |
Class Variable | is |
Undocumented |
Class Variable | is |
Undocumented |
Class Variable | supports |
Undocumented |
Method | _add |
Add a context option to this statement. |
Method | _compile |
Undocumented |
Method | _execute |
Undocumented |
Method | _execute |
Undocumented |
Method | _set |
Assign the compile options to a new value. |
Method | _update |
update the _compile_options with new keys. |
Class Variable | _executable |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _with |
Undocumented |
Class Variable | _with |
Undocumented |
Instance Variable | _compile |
Undocumented |
Instance Variable | _execution |
Undocumented |
Property | _effective |
Undocumented |
Inherited from StatementRole
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
):
Property | _propagate |
Undocumented |
Inherited from AllowsLambdaRole
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
):
Class Variable | allows |
Undocumented |
Inherited from HasCTE
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
):
Method | add |
Add one or more :class:`_sql.CTE` constructs to this statement. |
Method | cte |
Return a new :class:`_expression.CTE`, or Common Table Expression instance. |
Class Variable | _has |
Undocumented |
Class Variable | _independent |
Undocumented |
Class Variable | _independent |
Undocumented |
Inherited from SelectsRows
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
):
Method | _generate |
Generate column names as rendered in a SELECT statement by the compiler. |
Inherited from SupportsCloneAnnotations
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
):
Method | _annotate |
return a copy of this ClauseElement with annotations updated by the given dictionary. |
Method | _deannotate |
return a copy of this :class:`_expression.ClauseElement` with annotations removed. |
Method | _with |
return a copy of this ClauseElement with annotations replaced by the given dictionary. |
Class Variable | _clone |
Undocumented |
Inherited from Selectable
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
):
Method | corresponding |
Given a :class:`_expression.ColumnElement`, return the exported :class:`_expression.ColumnElement` object from the :attr:`_expression.Selectable.exported_columns` collection of this :class:`_expression... |
Method | replace |
Replace all occurrences of :class:`_expression.FromClause` 'old' with the given :class:`_expression.Alias` object, returning a copy of this :class:`_expression.FromClause`. |
Class Variable | is |
Undocumented |
Inherited from ReturnsRows
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
):
Method | is |
Return ``True`` if this :class:`.ReturnsRows` is 'derived' from the given :class:`.FromClause`. |
Property | selectable |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Inherited from SQLRole
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
):
Class Variable | uses |
Undocumented |
Inherited from DQLDMLClauseElement
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
):
Method | compile |
Compile this SQL expression. |
Method | _compiler |
Return a compiler appropriate for this ClauseElement, given a Dialect. |
Inherited from ClauseElement
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
):
Method | __bool__ |
Undocumented |
Method | __getstate__ |
Undocumented |
Method | __invert__ |
Undocumented |
Method | __repr__ |
Undocumented |
Method | compare |
Compare this :class:`_expression.ClauseElement` to the given :class:`_expression.ClauseElement`. |
Method | get |
Return immediate child :class:`.visitors.HasTraverseInternals` elements of this :class:`.visitors.HasTraverseInternals`. |
Method | params |
Return a copy with :func:`_expression.bindparam` elements replaced. |
Method | self |
Apply a 'grouping' to this :class:`_expression.ClauseElement`. |
Method | unique |
Return a copy with :func:`_expression.bindparam` elements replaced. |
Class Variable | is |
Undocumented |
Class Variable | negation |
Undocumented |
Property | description |
Undocumented |
Property | entity |
Undocumented |
Method | _clone |
Create a shallow copy of this ClauseElement. |
Method | _cloned |
Return the set consisting all cloned ancestors of this ClauseElement. |
Method | _negate |
Undocumented |
Method | _negate |
a hook to allow the right side of a binary expression to respond to a negation of the binary expression. |
Method | _replace |
Undocumented |
Method | _set |
Undocumented |
Method | _ungroup |
Return this :class:`_expression.ClauseElement` without any groupings. |
Method | _with |
in the context of binary expression, convert the type of this object to the one given. |
Class Variable | _cache |
Undocumented |
Class Variable | _gen |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Class Variable | _is |
Undocumented |
Property | _constructor |
return the 'constructor' for this ClauseElement. |
Property | _from |
Undocumented |
Property | _order |
Undocumented |
Inherited from SupportsAnnotations
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
):
Class Variable | proxy |
Undocumented |
Method | _gen |
Undocumented |
Property | _annotations |
Undocumented |
Inherited from MemoizedHasCacheKey
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
):
Method | _generate |
return a cache key. |
Inherited from HasCacheKey
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
, MemoizedHasCacheKey
):
Class Variable | inherit |
Indicate if this :class:`.HasCacheKey` instance should make use of the cache key generation scheme used by its immediate superclass. |
Class Method | _generate |
generate cache key dispatcher for a new class. |
Class Method | _generate |
Undocumented |
Method | _gen |
return an optional cache key. |
Class Variable | _generated |
Undocumented |
Class Variable | _hierarchy |
private attribute which may be set to False to prevent the inherit_cache warning from being emitted for a hierarchy of subclasses. |
Class Variable | _is |
Undocumented |
Inherited from Generative
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
, MemoizedHasCacheKey
, HasCacheKey
):
Method | _generate |
Undocumented |
Inherited from HasCopyInternals
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
, MemoizedHasCacheKey
, HasCacheKey
, Generative
):
Method | _copy |
Reassign internal elements to be clones of themselves. |
Inherited from CompilerElement
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
, MemoizedHasCacheKey
, HasCacheKey
, Generative
, HasCopyInternals
, ExternallyTraversible
, HasTraverseInternals
):
Method | __str__ |
Undocumented |
Class Variable | stringify |
Undocumented |
Inherited from Visitable
(via SelectBase
, SelectStatementRole
, ExecutableReturnsRows
, Executable
, StatementRole
, DMLSelectRole
, CompoundElementRole
, AllowsLambdaRole
, InElementRole
, HasCTE
, HasCTERole
, SelectsRows
, SupportsCloneAnnotations
, Selectable
, ReturnsRows
, ReturnsRowsRole
, SQLRole
, DQLDMLClauseElement
, ClauseElement
, SupportsWrappingAnnotations
, SupportsAnnotations
, MemoizedHasCacheKey
, HasCacheKey
, Generative
, HasCopyInternals
, ExternallyTraversible
, HasTraverseInternals
, CompilerElement
):
Method | __class |
Undocumented |
Method | __init |
Undocumented |
Class Method | _generate |
Undocumented |
Method | _compiler |
Undocumented |
Class Variable | _original |
Undocumented |
TextClause
, columns: List[ _ColumnExpressionArgument[ Any]]
, positional: bool
= False):
(source)
¶
Undocumented
def bindparams(self, *binds:
BindParameter[ Any]
, **bind_as_values: Any
) -> Self
:
(source)
¶
Undocumented
def selected_columns(self) ->
ColumnCollection[ str, KeyedColumnElement[ Any]]
:
(source)
¶
A :class:`_expression.ColumnCollection` representing the columns that this SELECT statement or similar construct returns in its result set, not including :class:`_sql.TextClause` constructs. This collection differs from the :attr:`_expression.FromClause.columns` collection of a :class:`_expression.FromClause` in that the columns within this collection cannot be directly nested inside another SELECT statement; a subquery must be applied first which provides for the necessary parenthesization required by SQL. For a :class:`_expression.TextualSelect` construct, the collection contains the :class:`_expression.ColumnElement` objects that were passed to the constructor, typically via the :meth:`_expression.TextClause.columns` method. .. versionadded:: 1.4
FromClause
, *, proxy_compound_columns: Optional[ Iterable[ Sequence[ ColumnElement[ Any]]]]
= None):
(source)
¶
Populate columns into an :class:`.AliasedReturnsRows` object.
TextClause
, columns: List[ NamedColumn[ Any]]
, positional: bool
= False):
(source)
¶
Undocumented