sqlalchemy.sql.functions.coalesce

Class Variable	inherit_cache	Indicate if this :class:`.HasCacheKey` instance should make use of the cache key generation scheme used by its immediate superclass.
Class Variable	_has_args	Undocumented

Inherited from ReturnTypeFromArgs:

Method

__init__

Construct a :class:`.Function`.

Inherited from GenericFunction (via ReturnTypeFromArgs):

Method	__init_subclass__	Undocumented
Class Variable	coerce_arguments	Undocumented
Class Variable	name	Undocumented
Instance Variable	clause_expr	Undocumented
Instance Variable	packagenames	Undocumented
Instance Variable	type	A :class:`_types.TypeEngine` object which refers to the SQL return type represented by this SQL function.
Class Method	_register_generic_function	Undocumented
Class Variable	_register	Undocumented

Inherited from Function (via ReturnTypeFromArgs, GenericFunction):

Class Variable	__visit_name__	Undocumented
Class Variable	identifier	Undocumented
Method	_bind_param	Undocumented
Class Variable	_traverse_internals	Undocumented

Inherited from FunctionElement (via ReturnTypeFromArgs, GenericFunction, Function):

Method	alias	Produce a :class:`_expression.Alias` construct against this :class:`.FunctionElement`.
Method	as_comparison	Interpret this expression as a boolean comparison between two values.
Method	clauses	Return the underlying :class:`.ClauseList` which contains the arguments for this :class:`.FunctionElement`.
Method	column_valued	Return this :class:`_functions.FunctionElement` as a column expression that selects from itself as a FROM clause.
Method	filter	Produce a FILTER clause against this function.
Method	over	Produce an OVER clause against this function.
Method	scalar_table_valued	Return a column expression that's against this :class:`_functions.FunctionElement` as a scalar table-valued expression.
Method	select	Produce a :func:`_expression.select` construct against this :class:`.FunctionElement`.
Method	self_group	Apply a 'grouping' to this :class:`_expression.ClauseElement`.
Method	table_valued	Return a :class:`_sql.TableValuedAlias` representation of this :class:`_functions.FunctionElement` with table-valued expressions added.
Method	within_group	Produce a WITHIN GROUP (ORDER BY expr) clause against this function.
Method	within_group_type	For types that define their return type as based on the criteria within a WITHIN GROUP (ORDER BY) expression, called by the :class:`.WithinGroup` construct.
Class Variable	primary_key	Return the iterable collection of :class:`_schema.Column` objects which comprise the primary key of this :class:`_selectable.FromClause`.
Property	c	synonym for :attr:`.FunctionElement.columns`.
Property	columns	The set of columns exported by this :class:`.FunctionElement`.
Property	entity_namespace	overrides FromClause.entity_namespace as functions are generally column expressions and not FromClauses.
Property	exported_columns	A :class:`_expression.ColumnCollection` that represents the "exported" columns of this :class:`_expression.Selectable`.
Method	_execute_on_connection	Undocumented
Class Variable	_is_clone_of	Undocumented
Class Variable	_non_anon_label	the 'name' that naturally applies this element when rendered in SQL.
Class Variable	_table_value_type	Undocumented
Class Variable	_with_ordinality	Undocumented
Property	_all_selected_columns	A sequence of column expression objects that represents the "selected" columns of this :class:`_expression.ReturnsRows`.
Property	_from_objects	Undocumented
Property	_proxy_key	Undocumented

Inherited from Executable (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement):

Method	execution_options	Set non-SQL options for the statement which take effect during execution.
Method	get_execution_options	Get the non-SQL options which will take effect during execution.
Method	options	Apply options to this statement.
Class Variable	is_delete	Undocumented
Class Variable	is_dml	Undocumented
Class Variable	is_insert	Undocumented
Class Variable	is_select	Undocumented
Class Variable	is_text	Undocumented
Class Variable	is_update	Undocumented
Class Variable	supports_execution	Undocumented
Method	_add_context_option	Add a context option to this statement.
Method	_compile_w_cache	Undocumented
Method	_execute_on_scalar	Undocumented
Method	_set_compile_options	Assign the compile options to a new value.
Method	_update_compile_options	update the _compile_options with new keys.
Class Variable	_executable_traverse_internals	Undocumented
Class Variable	_is_default_generator	Undocumented
Class Variable	_with_context_options	Undocumented
Class Variable	_with_options	Undocumented
Instance Variable	_compile_options	Undocumented
Instance Variable	_execution_options	Undocumented
Property	_effective_plugin_target	Undocumented

Inherited from StatementRole (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable):

Class Variable	__slots__	Undocumented
Class Variable	_role_name	Undocumented
Property	_propagate_attrs	Undocumented

Inherited from ColumnElement (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole):

Method	__getattr__	Undocumented
Method	cast	Produce a type cast, i.e. ``CAST(<expression> AS <type>)``.
Method	comparator	Undocumented
Method	label	Produce a column label, i.e. ``<columnname> AS <name>``.
Method	operate	Operate on an argument.
Method	reverse_operate	Reverse operate on an argument.
Method	shares_lineage	Return True if the given :class:`_expression.ColumnElement` has a common ancestor to this :class:`_expression.ColumnElement`.
Class Variable	foreign_keys	Undocumented
Class Variable	key	The 'key' that in some circumstances refers to this object in a Python namespace.
Property	anon_key_label	Undocumented
Property	anon_label	Undocumented
Property	base_columns	Undocumented
Property	expression	Return a column expression.
Property	proxy_set	set of all columns we are proxying
Method	_anon_label	Undocumented
Method	_compare_name_for_result	Return True if the given column element compares to this one when targeting within a result row.
Method	_dedupe_anon_label_idx	label to apply to a column that is anon labeled, but repeated in the SELECT, so that we have to make an "extra anon" label that disambiguates it from the previous appearance.
Method	_dedupe_anon_tq_label_idx	Undocumented
Method	_expression_label	a suggested label to use in the case that the column has no name, which should be used if possible as the explicit 'AS <label>' where this expression would normally have an anon label.
Method	_make_proxy	Create a new :class:`_expression.ColumnElement` representing this :class:`_expression.ColumnElement` as it appears in the select list of a descending selectable.
Method	_negate	Undocumented
Method	_tq_key_label	A label-based version of 'key' that in some circumstances refers to this object in a Python namespace.
Method	_uncached_proxy_list	An 'uncached' version of proxy set.
Class Variable	_allow_label_resolve	A flag that can be flipped to prevent a column from being resolvable by string label name.
Class Variable	_alt_names	Undocumented
Class Variable	_is_column_element	Undocumented
Class Variable	_is_implicitly_boolean	Undocumented
Class Variable	_render_label_in_columns_clause	A flag used by select._columns_plus_names that helps to determine we are actually going to render in terms of "SELECT <col> AS <label>". This flag can be returned as False for some Column objects that want to be rendered as simple "SELECT <col>"; typically columns that don't have any parent table and are named the same as what the label would be in any case.
Property	_anon_key_label	Provides a constant 'anonymous key label' for this ColumnElement.
Property	_anon_name_label	Provides a constant 'anonymous label' for this ColumnElement.
Property	_anon_tq_key_label	Undocumented
Property	_anon_tq_label	Undocumented
Property	_expanded_proxy_set	Undocumented
Property	_key_label	legacy; renamed to _tq_key_label
Property	_label	legacy; renamed to _tq_label
Property	_proxies	Undocumented
Property	_select_iterable	Undocumented
Property	_tq_label	The named label that can be used to target this column in a result set in a "table qualified" context.

Inherited from FromClause (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole):

Method	is_derived_from	Return ``True`` if this :class:`_expression.FromClause` is 'derived' from the given ``FromClause``.
Method	join	Return a :class:`_expression.Join` from this :class:`_expression.FromClause` to another :class:`FromClause`.
Method	outerjoin	Return a :class:`_expression.Join` from this :class:`_expression.FromClause` to another :class:`FromClause`, with the "isouter" flag set to True.
Method	tablesample	Return a TABLESAMPLE alias of this :class:`_expression.FromClause`.
Class Variable	is_selectable	Undocumented
Class Variable	named_with_column	Undocumented
Class Variable	schema	Define the 'schema' attribute for this :class:`_expression.FromClause`.
Property	description	A brief description of this :class:`_expression.FromClause`.
Method	_anonymous_fromclause	Undocumented
Method	_generate_fromclause_column_proxies	Populate columns into an :class:`.AliasedReturnsRows` object.
Method	_init_collections	Undocumented
Method	_is_lexical_equivalent	Return ``True`` if this :class:`_expression.FromClause` and the other represent the same lexical identity.
Method	_populate_column_collection	Called on subclasses to establish the .c collection.
Method	_refresh_for_new_column	Given a column added to the .c collection of an underlying selectable, produce the local version of that column, assuming this selectable ultimately should proxy this column.
Method	_reset_column_collection	Reset the attributes linked to the ``FromClause.c`` attribute.
Class Variable	_is_from_clause	Undocumented
Class Variable	_is_join	Undocumented
Class Variable	_use_schema_map	Undocumented
Instance Variable	_columns	Undocumented
Property	_cols_populated	Undocumented
Property	_hide_froms	Undocumented

Inherited from FromClauseRole (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole):

Class Variable

_is_subquery

Undocumented

Inherited from AllowsLambdaRole (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole):

Class Variable

allows_lambda

Undocumented

Inherited from UsesInspection (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole):

Class Variable	uses_inspection	Undocumented
Class Variable	_post_inspect	Undocumented

Inherited from SQLCoreOperations (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression):

Method	__add__	Implement the ``+`` operator.
Method	__and__	Implement the ``&`` operator.
Method	__contains__	Undocumented
Method	__eq__	Implement the ``==`` operator.
Method	__floordiv__	Implement the ``//`` operator.
Method	__ge__	Implement the ``>=`` operator.
Method	__getitem__	Implement the [] operator.
Method	__gt__	Implement the ``>`` operator.
Method	__invert__	Implement the ``~`` operator.
Method	__le__	Implement the ``<=`` operator.
Method	__lt__	Implement the ``<`` operator.
Method	__mod__	Implement the ``%`` operator.
Method	__mul__	Implement the ``*`` operator.
Method	__ne__	Implement the ``!=`` operator.
Method	__neg__	Implement the ``-`` operator.
Method	__or__	Implement the ``|`` operator.
Method	__radd__	Implement the ``+`` operator in reverse.
Method	__rfloordiv__	Implement the ``//`` operator in reverse.
Method	__rmod__	Implement the ``%`` operator in reverse.
Method	__rmul__	Implement the ``*`` operator in reverse.
Method	__rsub__	Implement the ``-`` operator in reverse.
Method	__rtruediv__	Implement the ``/`` operator in reverse.
Method	__sub__	Implement the ``-`` operator.
Method	__truediv__	Implement the ``/`` operator.
Method	all_	Produce an :func:`_expression.all_` clause against the parent object.
Method	any_	Produce an :func:`_expression.any_` clause against the parent object.
Method	asc	Produce a :func:`_expression.asc` clause against the parent object.
Method	between	Produce a :func:`_expression.between` clause against the parent object, given the lower and upper range.
Method	bool_op	Return a custom boolean operator.
Method	collate	Produce a :func:`_expression.collate` clause against the parent object, given the collation string.
Method	concat	Implement the 'concat' operator.
Method	contains	Implement the 'contains' operator.
Method	desc	Produce a :func:`_expression.desc` clause against the parent object.
Method	distinct	Produce a :func:`_expression.distinct` clause against the parent object.
Method	endswith	Implement the 'endswith' operator.
Method	ilike	Implement the ``ilike`` operator, e.g. case insensitive LIKE.
Method	in_	Implement the ``in`` operator.
Method	is_	Implement the ``IS`` operator.
Method	is_distinct_from	Implement the ``IS DISTINCT FROM`` operator.
Method	is_not	Implement the ``IS NOT`` operator.
Method	is_not_distinct_from	Implement the ``IS NOT DISTINCT FROM`` operator.
Method	isnot	Undocumented
Method	like	Implement the ``like`` operator.
Method	match	Implements a database-specific 'match' operator.
Method	not_ilike	implement the ``NOT ILIKE`` operator.
Method	not_in	implement the ``NOT IN`` operator.
Method	not_like	implement the ``NOT LIKE`` operator.
Method	notilike	Undocumented
Method	notin_	Undocumented
Method	notlike	Undocumented
Method	nulls_first	Produce a :func:`_expression.nulls_first` clause against the parent object.
Method	nulls_last	Produce a :func:`_expression.nulls_last` clause against the parent object.
Method	nullsfirst	Undocumented
Method	nullslast	Undocumented
Method	op	Produce a generic operator function.
Method	regexp_match	Implements a database-specific 'regexp match' operator.
Method	regexp_replace	Implements a database-specific 'regexp replace' operator.
Method	startswith	Implement the ``startswith`` operator.

Inherited from ColumnOperators (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole):

Method	__lshift__	implement the << operator.
Method	__rshift__	implement the >> operator.
Method	bitwise_and	Produce a bitwise AND operation, typically via the ``&`` operator.
Method	bitwise_lshift	Produce a bitwise LSHIFT operation, typically via the ``<<`` operator.
Method	bitwise_not	Produce a bitwise NOT operation, typically via the ``~`` operator.
Method	bitwise_or	Produce a bitwise OR operation, typically via the ``|`` operator.
Method	bitwise_rshift	Produce a bitwise RSHIFT operation, typically via the ``>>`` operator.
Method	bitwise_xor	Produce a bitwise XOR operation, typically via the ``^`` operator, or ``#`` for PostgreSQL.
Method	icontains	Implement the ``icontains`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.contains`.
Method	iendswith	Implement the ``iendswith`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.endswith`.
Method	isnot_distinct_from	Undocumented
Method	istartswith	Implement the ``istartswith`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.startswith`.
Class Variable	timetuple	Hack, allows datetime objects to be compared on the LHS.
Method	_rconcat	Implement an 'rconcat' operator.

Inherited from Selectable (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators):

Method	corresponding_column	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	lateral	Return a LATERAL alias of this :class:`_expression.Selectable`.
Method	replace_selectable	Replace all occurrences of :class:`_expression.FromClause` 'old' with the given :class:`_expression.Alias` object, returning a copy of this :class:`_expression.FromClause`.

Inherited from ReturnsRows (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable):

Property	selectable	Undocumented
Class Variable	_is_lateral	Undocumented
Class Variable	_is_returns_rows	Undocumented
Class Variable	_is_select_base	Undocumented
Class Variable	_is_select_statement	Undocumented

Inherited from DQLDMLClauseElement (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, 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 ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement):

Method	__bool__	Undocumented
Method	__getstate__	Undocumented
Method	__repr__	Undocumented
Method	compare	Compare this :class:`_expression.ClauseElement` to the given :class:`_expression.ClauseElement`.
Method	get_children	Return immediate child :class:`.visitors.HasTraverseInternals` elements of this :class:`.visitors.HasTraverseInternals`.
Method	params	Return a copy with :func:`_expression.bindparam` elements replaced.
Method	unique_params	Return a copy with :func:`_expression.bindparam` elements replaced.
Class Variable	is_clause_element	Undocumented
Class Variable	negation_clause	Undocumented
Method	_clone	Create a shallow copy of this ClauseElement.
Method	_cloned_set	Return the set consisting all cloned ancestors of this ClauseElement.
Method	_negate_in_binary	a hook to allow the right side of a binary expression to respond to a negation of the binary expression.
Method	_replace_params	Undocumented
Method	_set_propagate_attrs	Undocumented
Method	_ungroup	Return this :class:`_expression.ClauseElement` without any groupings.
Method	_with_binary_element_type	in the context of binary expression, convert the type of this object to the one given.
Class Variable	_cache_key_traversal	Undocumented
Class Variable	_gen_static_annotations_cache_key	Undocumented
Class Variable	_is_bind_parameter	Undocumented
Class Variable	_is_clause_list	Undocumented
Class Variable	_is_from_container	Undocumented
Class Variable	_is_immutable	Undocumented
Class Variable	_is_keyed_column_element	Undocumented
Class Variable	_is_lambda_element	Undocumented
Class Variable	_is_select_container	Undocumented
Class Variable	_is_singleton_constant	Undocumented
Class Variable	_is_star	Undocumented
Class Variable	_is_table	Undocumented
Class Variable	_is_text_clause	Undocumented
Class Variable	_is_textual	Undocumented
Property	_constructor	return the 'constructor' for this ClauseElement.
Property	_order_by_label_element	Undocumented

Inherited from SupportsWrappingAnnotations (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement):

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_annotations	return a copy of this ClauseElement with annotations replaced by the given dictionary.

Inherited from SupportsAnnotations (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations):

Method	_gen_annotations_cache_key	Undocumented
Property	_annotations_cache_key	Undocumented

Inherited from MemoizedHasCacheKey (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations):

Method

_generate_cache_key

return a cache key.

Inherited from HasCacheKey (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey):

Class Method	_generate_cache_attrs	generate cache key dispatcher for a new class.
Class Method	_generate_cache_key_for_object	Undocumented
Method	_gen_cache_key	return an optional cache key.
Class Variable	_generated_cache_key_traversal	Undocumented
Class Variable	_hierarchy_supports_caching	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_has_cache_key	Undocumented

Inherited from Generative (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey):

Method

_generate

Undocumented

Inherited from HasCopyInternals (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey, Generative):

Method

_copy_internals

Reassign internal elements to be clones of themselves.

Inherited from CompilerElement (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey, Generative, HasCopyInternals, ExternallyTraversible, HasTraverseInternals):

Method	__str__	Undocumented
Class Variable	stringify_dialect	Undocumented

Inherited from Visitable (via ReturnTypeFromArgs, GenericFunction, Function, FunctionElement, Executable, StatementRole, ColumnElement, ColumnArgumentOrKeyRole, ColumnArgumentRole, StatementOptionRole, WhereHavingRole, OnClauseRole, BinaryElementRole, OrderByRole, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, ByOfRole, UsesInspection, ColumnListRole, LimitOffsetRole, DMLColumnRole, DDLConstraintColumnRole, DDLExpressionRole, StructuralRole, SQLColumnExpression, SQLCoreOperations, ExpressionElementRole, TypedColumnsClauseRole, ColumnOperators, Operators, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey, Generative, HasCopyInternals, ExternallyTraversible, HasTraverseInternals, CompilerElement):

Method	__class_getitem__	Undocumented
Class Method	_generate_compiler_dispatch	Undocumented
Method	_compiler_dispatch	Undocumented
Class Variable	_original_compiler_dispatch	Undocumented