stubs/sqlalchemy/sql/expression.pyi

from .base import ColumnCollection as ColumnCollection
from .base import Executable as Executable
from .base import Generative as Generative
from .dml import Delete as Delete
from .dml import Insert as Insert
from .dml import Update as Update
from .elements import BinaryExpression as BinaryExpression
from .elements import BindParameter as BindParameter
from .elements import BooleanClauseList as BooleanClauseList
from .elements import Case as Case
from .elements import Cast as Cast
from .elements import ClauseElement as ClauseElement
from .elements import ClauseList as ClauseList
from .elements import CollectionAggregate as CollectionAggregate
from .elements import ColumnClause as ColumnClause
from .elements import ColumnElement as ColumnElement
from .elements import Extract as Extract
from .elements import False_ as False_
from .elements import FunctionFilter as FunctionFilter
from .elements import Grouping as Grouping
from .elements import Label as Label
from .elements import Null as Null
from .elements import Over as Over
from .elements import TextClause as TextClause
from .elements import True_ as True_
from .elements import Tuple as Tuple
from .elements import TypeClause as TypeClause
from .elements import TypeCoerce as TypeCoerce
from .elements import UnaryExpression as UnaryExpression
from .elements import WithinGroup as WithinGroup
from .elements import between as between
from .elements import collate as collate
from .elements import literal as literal
from .elements import literal_column as literal_column
from .elements import not_ as not_
from .elements import outparam as outparam
from .functions import Function as Function
from .functions import FunctionElement as FunctionElement
from .functions import func as func
from .functions import modifier as modifier
from .selectable import CTE as CTE
from .selectable import Alias as Alias
from .selectable import CompoundSelect as CompoundSelect
from .selectable import Exists as Exists
from .selectable import FromClause as FromClause
from .selectable import FromGrouping as FromGrouping
from .selectable import GenerativeSelect as GenerativeSelect
from .selectable import HasCTE as HasCTE
from .selectable import HasPrefixes as HasPrefixes
from .selectable import HasSuffixes as HasSuffixes
from .selectable import Join as Join
from .selectable import Lateral as Lateral
from .selectable import ScalarSelect as ScalarSelect
from .selectable import Select as Select
from .selectable import Selectable as Selectable
from .selectable import SelectBase as SelectBase
from .selectable import TableClause as TableClause
from .selectable import TableSample as TableSample
from .selectable import TextAsFrom as TextAsFrom
from .selectable import alias as alias
from .selectable import lateral as lateral
from .selectable import subquery as subquery
from .selectable import tablesample as tablesample

all_ = CollectionAggregate._create_all
any_ = CollectionAggregate._create_any
and_ = BooleanClauseList.and_
or_ = BooleanClauseList.or_
bindparam = BindParameter
select = Select
text = TextClause._create_text
table = TableClause
column = ColumnClause
over = Over
within_group = WithinGroup
label = Label
case = Case
cast = Cast
extract = Extract
tuple_ = Tuple
except_ = CompoundSelect._create_except
except_all = CompoundSelect._create_except_all
intersect = CompoundSelect._create_intersect
intersect_all = CompoundSelect._create_intersect_all
union = CompoundSelect._create_union
union_all = CompoundSelect._create_union_all
exists = Exists
nullsfirst = UnaryExpression._create_nullsfirst
nullslast = UnaryExpression._create_nullslast
asc = UnaryExpression._create_asc
desc = UnaryExpression._create_desc
distinct = UnaryExpression._create_distinct
type_coerce = TypeCoerce
true = True_._instance
false = False_._instance
null = Null._instance
join = Join._create_join
outerjoin = Join._create_outerjoin
insert = Insert
update = Update
delete = Delete
funcfilter = FunctionFilter

# old names for compatibility
_Executable = Executable
_BindParamClause = BindParameter
_Label = Label
_SelectBase = SelectBase
_BinaryExpression = BinaryExpression
_Cast = Cast
_Null = Null
_False = False_
_True = True_
_TextClause = TextClause
_UnaryExpression = UnaryExpression
_Case = Case
_Tuple = Tuple
_Over = Over
_Generative = Generative
_TypeClause = TypeClause
_Extract = Extract
_Exists = Exists
_Grouping = Grouping
_FromGrouping = FromGrouping
_ScalarSelect = ScalarSelect