1
Column Elements and Expressions
2
===============================
4
.. module:: sqlalchemy.sql.expression
6
The most fundamental part of the SQL expression API are the "column elements",
7
which allow for basic SQL expression support. The core of all SQL expression
8
constructs is the :class:`.ClauseElement`, which is the base for several
9
sub-branches. The :class:`.ColumnElement` class is the fundamental unit
10
used to construct any kind of typed SQL expression.
12
.. autofunction:: and_
16
.. autofunction:: between
18
.. autofunction:: bindparam
20
.. autofunction:: case
22
.. autofunction:: cast
24
.. autofunction:: sqlalchemy.sql.expression.column
26
.. autofunction:: collate
28
.. autofunction:: desc
30
.. autofunction:: distinct
32
.. autofunction:: extract
34
.. autofunction:: false
38
.. autofunction:: label
40
.. autofunction:: literal
42
.. autofunction:: literal_column
44
.. autofunction:: not_
46
.. autofunction:: null
48
.. autofunction:: nullsfirst
50
.. autofunction:: nullslast
54
.. autofunction:: outparam
56
.. autofunction:: over
58
.. autofunction:: text
60
.. autofunction:: true
62
.. autofunction:: tuple_
64
.. autofunction:: type_coerce
66
.. autoclass:: BinaryExpression
71
.. autoclass:: BindParameter
75
.. autoclass:: ClauseElement
79
.. autoclass:: ClauseList
83
.. autoclass:: ColumnClause
87
.. autoclass:: ColumnCollection
91
.. autoclass:: ColumnElement
95
.. autoclass:: sqlalchemy.sql.operators.ColumnOperators
101
.. autoclass:: sqlalchemy.sql.operators.custom_op
104
.. autoclass:: sqlalchemy.sql.operators.Operators
108
.. autoclass:: UnaryExpression