sqlalchemy.sql.elements

module documentation

Core SQL expression elements, including _expression.ClauseElement, _expression.ColumnElement, and derived classes.
Class ​Binary​Expression Represent an expression that is LEFT <operator> RIGHT.
Class ​Bind​Parameter Represent a "bound expression".
Class ​Case Represent a CASE expression.
Class ​Cast Represent a CAST expression.
Class ​Clause​List Describe a list of clauses, separated by an operator.
Class ​Column​Clause Represents a column expression from any textual string.
Class ​Extract Represent a SQL EXTRACT clause, extract(field FROM expr).
Class ​False_ Represent the false keyword, or equivalent, in a SQL statement.
Class ​Function​Filter Represent a function FILTER clause.
Class ​Label Represents a column label (AS).
Class ​Null Represent the NULL keyword in a SQL statement.
Class ​Over Represent an OVER clause.
Class ​Text​Clause Represent a literal SQL text fragment.
Class ​True_ Represent the true keyword, or equivalent, in a SQL statement.
Class ​Tuple Represent a SQL tuple.
Class ​Type​Coerce Represent a Python-side type-coercion wrapper.
Class ​Unary​Expression Define a 'unary' expression.
Class ​Within​Group Represent a WITHIN GROUP (ORDER BY) clause.
Class ​Wraps​Column​Expression Mixin that defines a _expression.ColumnElement as a wrapper with special labeling behavior for an expression that already has a name.
Constant RANGE​_CURRENT Undocumented
Constant RANGE​_UNBOUNDED Undocumented
Class ​_anonymous​_label A unicode subclass used to identify anonymously generated names.
Class _​Identified​Clause Undocumented
Class ​_label​_reference Wrap a column expression as it appears in a 'reference' context.
Class ​_textual​_label​_reference Undocumented
Class ​_truncated​_label A unicode subclass used to identify symbolic " "names that may require truncation.
Class ​Annotated​Column​Element No class docstring; 3/5 properties, 0/2 method documented
Class ​As​Boolean Undocumented
Class ​Boolean​Clause​List No class docstring; 0/1 property, 0/6 instance variable, 0/2 class variable, 0/3 method, 2/6 class methods documented
Class ​Collation​Clause Undocumented
Class ​Collection​Aggregate Forms the basis for right-hand collection operator modifiers ANY and ALL.
Class conv Mark a string indicating that a name has already been converted by a naming convention.
Class ​Grouped​Element Represent any parenthesized expression
Class ​Grouping Represent a grouping within a column expression
Class ​Index​Expression Represent the class of expressions that are like an "index" operation.
Class ​Named​Column No class docstring; 0/1 property, 0/2 class variable, 2/8 methods documented
Class ​Release​Savepoint​Clause Undocumented
Class ​Rollback​To​Savepoint​Clause Undocumented
Class ​Savepoint​Clause Undocumented
Class ​Slice Represent SQL for a Python array-slice object.
Class ​Table​Valued​Column Undocumented
Class ​Type​Clause Handle a type keyword in a SQL statement.
Function ​_corresponding​_column​_or​_error Undocumented
Function ​_find​_columns locate Column objects within the given expression.
Function ​_type​_from​_args Undocumented
Constant ​_NONE​_NAME indicate a 'deferred' name that was ultimately the value None.
RANGE_CURRENT =

Undocumented

Value
util.symbol('RANGE_CURRENT')
RANGE_UNBOUNDED =

Undocumented

Value
util.symbol('RANGE_UNBOUNDED')
def _corresponding_column_or_error(fromclause, column, require_embedded=False):

Undocumented

def _find_columns(clause):
locate Column objects within the given expression.
def _type_from_args(args):

Undocumented

_NONE_NAME =
indicate a 'deferred' name that was ultimately the value None.
Value
util.symbol('NONE_NAME')