expression.py 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159
  1. # sql/expression.py
  2. # Copyright (C) 2005-2025 the SQLAlchemy authors and contributors
  3. # <see AUTHORS file>
  4. #
  5. # This module is part of SQLAlchemy and is released under
  6. # the MIT License: https://www.opensource.org/licenses/mit-license.php
  7. """Defines the public namespace for SQL expression constructs."""
  8. from __future__ import annotations
  9. from ._dml_constructors import delete as delete
  10. from ._dml_constructors import insert as insert
  11. from ._dml_constructors import update as update
  12. from ._elements_constructors import all_ as all_
  13. from ._elements_constructors import and_ as and_
  14. from ._elements_constructors import any_ as any_
  15. from ._elements_constructors import asc as asc
  16. from ._elements_constructors import between as between
  17. from ._elements_constructors import bindparam as bindparam
  18. from ._elements_constructors import bitwise_not as bitwise_not
  19. from ._elements_constructors import case as case
  20. from ._elements_constructors import cast as cast
  21. from ._elements_constructors import collate as collate
  22. from ._elements_constructors import column as column
  23. from ._elements_constructors import desc as desc
  24. from ._elements_constructors import distinct as distinct
  25. from ._elements_constructors import extract as extract
  26. from ._elements_constructors import false as false
  27. from ._elements_constructors import funcfilter as funcfilter
  28. from ._elements_constructors import label as label
  29. from ._elements_constructors import not_ as not_
  30. from ._elements_constructors import null as null
  31. from ._elements_constructors import nulls_first as nulls_first
  32. from ._elements_constructors import nulls_last as nulls_last
  33. from ._elements_constructors import or_ as or_
  34. from ._elements_constructors import outparam as outparam
  35. from ._elements_constructors import over as over
  36. from ._elements_constructors import text as text
  37. from ._elements_constructors import true as true
  38. from ._elements_constructors import try_cast as try_cast
  39. from ._elements_constructors import tuple_ as tuple_
  40. from ._elements_constructors import type_coerce as type_coerce
  41. from ._elements_constructors import within_group as within_group
  42. from ._selectable_constructors import alias as alias
  43. from ._selectable_constructors import cte as cte
  44. from ._selectable_constructors import except_ as except_
  45. from ._selectable_constructors import except_all as except_all
  46. from ._selectable_constructors import exists as exists
  47. from ._selectable_constructors import intersect as intersect
  48. from ._selectable_constructors import intersect_all as intersect_all
  49. from ._selectable_constructors import join as join
  50. from ._selectable_constructors import lateral as lateral
  51. from ._selectable_constructors import outerjoin as outerjoin
  52. from ._selectable_constructors import select as select
  53. from ._selectable_constructors import table as table
  54. from ._selectable_constructors import tablesample as tablesample
  55. from ._selectable_constructors import union as union
  56. from ._selectable_constructors import union_all as union_all
  57. from ._selectable_constructors import values as values
  58. from ._typing import ColumnExpressionArgument as ColumnExpressionArgument
  59. from .base import _from_objects as _from_objects
  60. from .base import _select_iterables as _select_iterables
  61. from .base import ColumnCollection as ColumnCollection
  62. from .base import Executable as Executable
  63. from .cache_key import CacheKey as CacheKey
  64. from .dml import Delete as Delete
  65. from .dml import Insert as Insert
  66. from .dml import Update as Update
  67. from .dml import UpdateBase as UpdateBase
  68. from .dml import ValuesBase as ValuesBase
  69. from .elements import _truncated_label as _truncated_label
  70. from .elements import BinaryExpression as BinaryExpression
  71. from .elements import BindParameter as BindParameter
  72. from .elements import BooleanClauseList as BooleanClauseList
  73. from .elements import Case as Case
  74. from .elements import Cast as Cast
  75. from .elements import ClauseElement as ClauseElement
  76. from .elements import ClauseList as ClauseList
  77. from .elements import CollectionAggregate as CollectionAggregate
  78. from .elements import ColumnClause as ColumnClause
  79. from .elements import ColumnElement as ColumnElement
  80. from .elements import ExpressionClauseList as ExpressionClauseList
  81. from .elements import Extract as Extract
  82. from .elements import False_ as False_
  83. from .elements import FunctionFilter as FunctionFilter
  84. from .elements import Grouping as Grouping
  85. from .elements import Label as Label
  86. from .elements import literal as literal
  87. from .elements import literal_column as literal_column
  88. from .elements import Null as Null
  89. from .elements import Over as Over
  90. from .elements import quoted_name as quoted_name
  91. from .elements import ReleaseSavepointClause as ReleaseSavepointClause
  92. from .elements import RollbackToSavepointClause as RollbackToSavepointClause
  93. from .elements import SavepointClause as SavepointClause
  94. from .elements import SQLColumnExpression as SQLColumnExpression
  95. from .elements import TextClause as TextClause
  96. from .elements import True_ as True_
  97. from .elements import TryCast as TryCast
  98. from .elements import Tuple as Tuple
  99. from .elements import TypeClause as TypeClause
  100. from .elements import TypeCoerce as TypeCoerce
  101. from .elements import UnaryExpression as UnaryExpression
  102. from .elements import WithinGroup as WithinGroup
  103. from .functions import func as func
  104. from .functions import Function as Function
  105. from .functions import FunctionElement as FunctionElement
  106. from .functions import modifier as modifier
  107. from .lambdas import lambda_stmt as lambda_stmt
  108. from .lambdas import LambdaElement as LambdaElement
  109. from .lambdas import StatementLambdaElement as StatementLambdaElement
  110. from .operators import ColumnOperators as ColumnOperators
  111. from .operators import custom_op as custom_op
  112. from .operators import Operators as Operators
  113. from .selectable import Alias as Alias
  114. from .selectable import AliasedReturnsRows as AliasedReturnsRows
  115. from .selectable import CompoundSelect as CompoundSelect
  116. from .selectable import CTE as CTE
  117. from .selectable import Exists as Exists
  118. from .selectable import FromClause as FromClause
  119. from .selectable import FromGrouping as FromGrouping
  120. from .selectable import GenerativeSelect as GenerativeSelect
  121. from .selectable import HasCTE as HasCTE
  122. from .selectable import HasPrefixes as HasPrefixes
  123. from .selectable import HasSuffixes as HasSuffixes
  124. from .selectable import Join as Join
  125. from .selectable import LABEL_STYLE_DEFAULT as LABEL_STYLE_DEFAULT
  126. from .selectable import (
  127. LABEL_STYLE_DISAMBIGUATE_ONLY as LABEL_STYLE_DISAMBIGUATE_ONLY,
  128. )
  129. from .selectable import LABEL_STYLE_NONE as LABEL_STYLE_NONE
  130. from .selectable import (
  131. LABEL_STYLE_TABLENAME_PLUS_COL as LABEL_STYLE_TABLENAME_PLUS_COL,
  132. )
  133. from .selectable import Lateral as Lateral
  134. from .selectable import ReturnsRows as ReturnsRows
  135. from .selectable import ScalarSelect as ScalarSelect
  136. from .selectable import ScalarValues as ScalarValues
  137. from .selectable import Select as Select
  138. from .selectable import Selectable as Selectable
  139. from .selectable import SelectBase as SelectBase
  140. from .selectable import SelectLabelStyle as SelectLabelStyle
  141. from .selectable import Subquery as Subquery
  142. from .selectable import TableClause as TableClause
  143. from .selectable import TableSample as TableSample
  144. from .selectable import TableValuedAlias as TableValuedAlias
  145. from .selectable import TextAsFrom as TextAsFrom
  146. from .selectable import TextualSelect as TextualSelect
  147. from .selectable import Values as Values
  148. from .visitors import Visitable as Visitable
  149. nullsfirst = nulls_first
  150. """Synonym for the :func:`.nulls_first` function."""
  151. nullslast = nulls_last
  152. """Synonym for the :func:`.nulls_last` function."""