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