SQL Statements and Expressions API

• Column Elements and Expressions
  • • and_()
    • case()
    • column()
    • distinct()
    • false()
    • lambda_stmt()
    • literal_column()
    • null()
    • outparam()
    • true()
    • type_coerce()
  • Column Element Modifier Constructors
    • any_()
    • between()
    • desc()
    • label()
    • nulls_last()
    • within_group()
  • • BinaryExpression
    • Case
    • ClauseList
    • ColumnCollection
    • ColumnOperators
    • False_
    • Label
    • Operators
    • SQLColumnExpression
    • Tuple
    • WrapsColumnExpression
    • TypeCoerce
• Operator Reference
  • IN Comparisons
    • Empty IN Expressions
    • Tuple IN Expressions
  • Identity Comparisons
  • String Containment
  • String Alteration
  • Using Conjunctions and Negations
• SELECT and Related Constructs
  • • except_()
    • exists()
    • intersect_all()
    • table()
    • union_all()
  • Selectable Class Documentation
    • AliasedReturnsRows
    • CTE
    • Exists
    • GenerativeSelect
    • HasPrefixes
    • Join
    • ReturnsRows
    • Select
    • SelectBase
    • TableClause
    • TableValuedAlias
    • Values
  • Label Style Constants
• Insert, Updates, Deletes
  • • delete()
    • update()
  • • Delete
    • Update
    • ValuesBase
• • Function API
    • Function
    • GenericFunction
  • Selected “Known” Functions
    • char_length
    • concat
    • cube
    • current_date
    • current_timestamp
    • dense_rank
    • localtime
    • max
    • mode
    • now
    • percentile_cont
    • random
    • rollup
    • sum
    • user
• • Synopsis
  • Compiling sub-elements of a custom expression construct
  • Changing the default compilation of existing constructs
  • Enabling Caching Support for Custom Constructs
  • • “UTC timestamp” function
    • “false” expression
  • deregister()
• • Deserializer()
  • dumps()
• SQL Expression Language Foundational Constructs
  • • CacheKey.bindparams
    • CacheKey.to_offline_string()
  • • ClauseElement.compare()
    • ClauseElement.get_children()
    • ClauseElement.params()
    • ClauseElement.unique_params()
  • • DialectKWArgs.argument_for()
    • DialectKWArgs.dialect_options
  • HasCacheKey
  • LambdaElement
  • • StatementLambdaElement.add_criteria()
    • StatementLambdaElement.is_dml
    • StatementLambdaElement.is_select
    • StatementLambdaElement.is_update
• Visitor and Traversal Utilities
  • • ExternalTraversal.chain()
    • ExternalTraversal.traverse()
  • InternalTraversal
    • InternalTraversal.dp_anon_name
    • InternalTraversal.dp_clauseelement
    • InternalTraversal.dp_clauseelement_tuple
    • InternalTraversal.dp_dialect_options
    • InternalTraversal.dp_dml_ordered_values
    • InternalTraversal.dp_fromclause_canonical_column_collection
    • InternalTraversal.dp_has_cache_key
    • InternalTraversal.dp_has_cache_key_tuples
    • InternalTraversal.dp_inspectable
    • InternalTraversal.dp_multi
    • InternalTraversal.dp_named_ddl_element
    • InternalTraversal.dp_plain_dict
    • InternalTraversal.dp_prefix_sequence
    • InternalTraversal.dp_statement_hint_list
    • InternalTraversal.dp_string_clauseelement_dict
    • InternalTraversal.dp_string_multi_dict
    • InternalTraversal.dp_type
  • Visitable
  • cloned_traverse()
  • replacement_traverse()