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