Release: 2.0.36
current release
| Release Date: October 15, 2024
SQLAlchemy 2.0 Documentation
SQLAlchemy Core
- SQL Statements and Expressions API¶
- Schema Definition Language
- SQL Datatype Objects
- Engine and Connection Use
- Core API Basics
Project Versions
- Previous: SQLAlchemy Core
- Next: Column Elements and Expressions
- Up: Home
- On this page:
SQL Statements and Expressions API¶
This section presents the API reference for the SQL Expression Language. For an introduction, start with Working with Data in the SQLAlchemy Unified Tutorial.
- Column Elements and Expressions
- Column Element Foundational Constructors
- Column Element Modifier Constructors
- Column Element Class Documentation
BinaryExpression
BindParameter
Case
Cast
ClauseList
ColumnClause
ColumnCollection
ColumnElement
ColumnExpressionArgument
ColumnOperators
Extract
False_
FunctionFilter
Label
Null
Operators
Over
SQLColumnExpression
TextClause
TryCast
Tuple
WithinGroup
WrapsColumnExpression
True_
TypeCoerce
UnaryExpression
- Column Element Typing Utilities
- Operator Reference
- SELECT and Related Constructs
- Insert, Updates, Deletes
- SQL and Generic Functions
- Function API
- Selected “Known” Functions
aggregate_strings
array_agg
char_length
coalesce
concat
count
cube
cume_dist
current_date
current_time
current_timestamp
current_user
dense_rank
grouping_sets
localtime
localtimestamp
max
min
mode
next_value
now
percent_rank
percentile_cont
percentile_disc
random
rank
rollup
session_user
sum
sysdate
user
- Custom SQL Constructs and Compilation Extension
- Expression Serializer Extension
- SQL Expression Language Foundational Constructs
- Visitor and Traversal Utilities
ExternalTraversal
InternalTraversal
InternalTraversal.dp_annotations_key
InternalTraversal.dp_anon_name
InternalTraversal.dp_boolean
InternalTraversal.dp_clauseelement
InternalTraversal.dp_clauseelement_list
InternalTraversal.dp_clauseelement_tuple
InternalTraversal.dp_clauseelement_tuples
InternalTraversal.dp_dialect_options
InternalTraversal.dp_dml_multi_values
InternalTraversal.dp_dml_ordered_values
InternalTraversal.dp_dml_values
InternalTraversal.dp_fromclause_canonical_column_collection
InternalTraversal.dp_fromclause_ordered_set
InternalTraversal.dp_has_cache_key
InternalTraversal.dp_has_cache_key_list
InternalTraversal.dp_has_cache_key_tuples
InternalTraversal.dp_ignore
InternalTraversal.dp_inspectable
InternalTraversal.dp_inspectable_list
InternalTraversal.dp_multi
InternalTraversal.dp_multi_list
InternalTraversal.dp_named_ddl_element
InternalTraversal.dp_operator
InternalTraversal.dp_plain_dict
InternalTraversal.dp_plain_obj
InternalTraversal.dp_prefix_sequence
InternalTraversal.dp_propagate_attrs
InternalTraversal.dp_statement_hint_list
InternalTraversal.dp_string
InternalTraversal.dp_string_clauseelement_dict
InternalTraversal.dp_string_list
InternalTraversal.dp_string_multi_dict
InternalTraversal.dp_table_hint_list
InternalTraversal.dp_type
InternalTraversal.dp_unknown_structure
Visitable
anon_map
cloned_traverse()
iterate()
replacement_traverse()
traverse()
traverse_using()
Previous:
SQLAlchemy Core
Next:
Column Elements and Expressions
© Copyright 2007-2024, the SQLAlchemy authors and contributors.
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 7.2.6. Documentation last generated: Fri 08 Nov 2024 08:41:19 AM EST