1Column Elements and Expressions
2===============================
3
4.. module:: sqlalchemy.sql.expression
5
6The most fundamental part of the SQL expression API are the "column elements",
7which allow for basic SQL expression support.   The core of all SQL expression
8constructs is the :class:`.ClauseElement`, which is the base for several
9sub-branches.  The :class:`.ColumnElement` class is the fundamental unit
10used to construct any kind of typed SQL expression.
11
12.. autofunction:: and_
13
14.. autofunction:: asc
15
16.. autofunction:: between
17
18.. autofunction:: bindparam
19
20.. autofunction:: case
21
22.. autofunction:: cast
23
24.. autofunction:: sqlalchemy.sql.expression.column
25
26.. autofunction:: collate
27
28.. autofunction:: desc
29
30.. autofunction:: distinct
31
32.. autofunction:: extract
33
34.. autofunction:: false
35
36.. autodata:: func
37
38.. autofunction:: funcfilter
39
40.. autofunction:: label
41
42.. autofunction:: literal
43
44.. autofunction:: literal_column
45
46.. autofunction:: not_
47
48.. autofunction:: null
49
50.. autofunction:: nullsfirst
51
52.. autofunction:: nullslast
53
54.. autofunction:: or_
55
56.. autofunction:: outparam
57
58.. autofunction:: over
59
60.. autofunction:: text
61
62.. autofunction:: true
63
64.. autofunction:: tuple_
65
66.. autofunction:: type_coerce
67
68.. autoclass:: BinaryExpression
69   :members:
70
71.. autoclass:: BindParameter
72   :members:
73
74.. autoclass:: Case
75   :members:
76
77.. autoclass:: Cast
78   :members:
79
80.. autoclass:: ClauseElement
81   :members:
82
83
84.. autoclass:: ClauseList
85   :members:
86
87
88.. autoclass:: ColumnClause
89   :members:
90
91.. autoclass:: ColumnCollection
92   :members:
93
94
95.. autoclass:: ColumnElement
96   :members:
97   :inherited-members:
98   :undoc-members:
99
100.. autoclass:: sqlalchemy.sql.operators.ColumnOperators
101   :members:
102   :special-members:
103   :inherited-members:
104
105.. autoclass:: sqlalchemy.sql.base.DialectKWArgs
106   :members:
107
108.. autoclass:: Extract
109   :members:
110
111.. autoclass:: sqlalchemy.sql.elements.False_
112   :members:
113
114.. autoclass:: FunctionFilter
115   :members:
116
117.. autoclass:: Label
118   :members:
119
120.. autoclass:: sqlalchemy.sql.elements.Null
121   :members:
122
123.. autoclass:: Over
124   :members:
125
126.. autoclass:: TextClause
127   :members:
128
129.. autoclass:: Tuple
130   :members:
131
132.. autoclass:: sqlalchemy.sql.elements.True_
133   :members:
134
135.. autoclass:: sqlalchemy.sql.operators.custom_op
136   :members:
137
138.. autoclass:: sqlalchemy.sql.operators.Operators
139   :members:
140   :special-members:
141
142.. autoclass:: sqlalchemy.sql.elements.quoted_name
143
144.. autoclass:: UnaryExpression
145   :members:
146
147
148
149