1use super::array_comparison::{AsInExpression, In, NotIn};
5use super::grouped::Grouped;
6use super::select_by::SelectBy;
7use super::{AsExpression, Expression};
8use crate::expression;
9#[cfg(any(feature = "postgres_backend", feature = "__sqlite-shared"))]
10use crate::expression_methods::JsonIndex;
11use crate::expression_methods::PreferredBoolSqlType;
12use crate::sql_types;
13use alloc::string::String;
14
15pub type SqlTypeOf<Expr> = <Expr as Expression>::SqlType;
17
18pub type AsExpr<Item, TargetExpr> = AsExprOf<Item, SqlTypeOf<TargetExpr>>;
20
21pub type AsExprOf<Item, Type> = <Item as AsExpression<Type>>::Expression;
23
24pub type Eq<Lhs, Rhs> = Grouped<super::operators::Eq<Lhs, AsExpr<Rhs, Lhs>>>;
27
28pub type NotEq<Lhs, Rhs> = Grouped<super::operators::NotEq<Lhs, AsExpr<Rhs, Lhs>>>;
31
32#[doc(hidden)] pub type Ne<Lhs, Rhs> = NotEq<Lhs, Rhs>;
34
35pub type EqAny<Lhs, Rhs> = Grouped<In<Lhs, <Rhs as AsInExpression<SqlTypeOf<Lhs>>>::InExpression>>;
38
39pub type NeAny<Lhs, Rhs> =
42 Grouped<NotIn<Lhs, <Rhs as AsInExpression<SqlTypeOf<Lhs>>>::InExpression>>;
43
44#[doc(hidden)] pub type NeAll<Lhs, Rhs> = NeAny<Lhs, Rhs>;
46
47pub type IsNull<Expr> = Grouped<super::operators::IsNull<Expr>>;
50
51pub type IsNotNull<Expr> = Grouped<super::operators::IsNotNull<Expr>>;
54
55pub type Gt<Lhs, Rhs> = Grouped<super::operators::Gt<Lhs, AsExpr<Rhs, Lhs>>>;
58
59pub type GtEq<Lhs, Rhs> = Grouped<super::operators::GtEq<Lhs, AsExpr<Rhs, Lhs>>>;
62
63#[doc(hidden)] pub type Ge<Lhs, Rhs> = GtEq<Lhs, Rhs>;
65
66pub type Lt<Lhs, Rhs> = Grouped<super::operators::Lt<Lhs, AsExpr<Rhs, Lhs>>>;
69
70pub type LtEq<Lhs, Rhs> = Grouped<super::operators::LtEq<Lhs, AsExpr<Rhs, Lhs>>>;
73
74#[doc(hidden)] pub type Le<Lhs, Rhs> = LtEq<Lhs, Rhs>;
76
77pub type Between<Lhs, Lower, Upper> = Grouped<
80 super::operators::Between<Lhs, super::operators::And<AsExpr<Lower, Lhs>, AsExpr<Upper, Lhs>>>,
81>;
82
83pub type NotBetween<Lhs, Lower, Upper> = Grouped<
86 super::operators::NotBetween<
87 Lhs,
88 super::operators::And<AsExpr<Lower, Lhs>, AsExpr<Upper, Lhs>>,
89 >,
90>;
91
92pub type Concat<Lhs, Rhs> = Grouped<super::operators::Concat<Lhs, AsExpr<Rhs, Lhs>>>;
95
96pub type Cast<Expr, ST> = super::cast::Cast<Expr, ST>;
99
100pub type Desc<Expr> = super::operators::Desc<Expr>;
103
104pub type Asc<Expr> = super::operators::Asc<Expr>;
107
108pub type Nullable<Expr> = super::nullable::Nullable<Expr>;
111
112pub type AssumeNotNull<Expr> = super::assume_not_null::AssumeNotNull<Expr>;
115
116pub type And<Lhs, Rhs, ST = <Rhs as PreferredBoolSqlType>::PreferredSqlType> =
119 Grouped<super::operators::And<Lhs, AsExprOf<Rhs, ST>>>;
120
121pub type Or<Lhs, Rhs, ST = <Rhs as PreferredBoolSqlType>::PreferredSqlType> =
124 Grouped<super::operators::Or<Lhs, AsExprOf<Rhs, ST>>>;
125
126pub type Escape<Lhs> = Grouped<
129 super::operators::Escape<
130 <Lhs as crate::expression_methods::EscapeExpressionMethods>::TextExpression,
131 AsExprOf<String, sql_types::VarChar>,
132 >,
133>;
134
135pub type Like<Lhs, Rhs> = Grouped<super::operators::Like<Lhs, AsExprOf<Rhs, SqlTypeOf<Lhs>>>>;
138
139pub type NotLike<Lhs, Rhs> = Grouped<super::operators::NotLike<Lhs, AsExprOf<Rhs, SqlTypeOf<Lhs>>>>;
142
143#[allow(non_camel_case_types)] pub type case_when<C, T, ST = <T as Expression>::SqlType> = expression::case_when::CaseWhen<
146 expression::case_when::CaseWhenConditionsLeaf<Grouped<C>, Grouped<AsExprOf<T, ST>>>,
147 expression::case_when::NoElseExpression,
148>;
149pub type When<W, C, T> = expression::case_when::CaseWhen<
151 expression::case_when::CaseWhenConditionsIntermediateNode<
152 Grouped<C>,
153 Grouped<AsExprOf<T, <W as expression::case_when::CaseWhenTypesExtractor>::OutputExpressionSpecifiedSqlType>>,
154 <W as expression::case_when::CaseWhenTypesExtractor>::Whens,
155 >,
156 <W as expression::case_when::CaseWhenTypesExtractor>::Else,
157>;
158pub type Otherwise<W, E> = expression::case_when::CaseWhen<
160 <W as expression::case_when::CaseWhenTypesExtractor>::Whens,
161 expression::case_when::ElseExpression<Grouped<AsExprOf<E, <W as expression::case_when::CaseWhenTypesExtractor>::OutputExpressionSpecifiedSqlType>>>,
162>;
163
164pub type AsSelect<Source, DB> = SelectBy<Source, DB>;
166
167pub type IntoSql<Item, SqlType> = AsExprOf<Item, SqlType>;
169
170pub type Field<Alias, Field> = Fields<Alias, Field>;
172
173pub type Fields<Alias, Fields> = <Fields as crate::query_source::aliasing::FieldAliasMapper<
175 <Alias as crate::query_source::aliasing::GetAliasSourceFromAlias>::Source,
176>>::Out;
177
178pub type Add<L, R> = <L as ::core::ops::Add<R>>::Output;
181
182pub type Sub<L, R> = <L as ::core::ops::Sub<R>>::Output;
185
186pub type Mul<L, R> = <L as ::core::ops::Mul<R>>::Output;
189
190pub type Div<L, R> = <L as ::core::ops::Div<R>>::Output;
193
194#[doc(inline)]
199#[allow(unreachable_pub)]
200pub use super::functions::helper_types::*;
201
202#[doc(inline)]
203#[cfg(all(feature = "postgres_backend", not(feature = "__sqlite-shared")))]
204#[allow(unreachable_pub)]
205pub use crate::pg::expression::helper_types::*;
206
207#[doc(inline)]
208#[cfg(all(feature = "postgres_backend", feature = "__sqlite-shared"))]
209#[allow(unreachable_pub)]
210pub use crate::pg::expression::helper_types::*;
211
212#[doc(inline)]
213#[cfg(all(feature = "__sqlite-shared", not(feature = "postgres_backend")))]
214#[allow(unreachable_pub)]
215pub use crate::sqlite::expression::helper_types::*;
216
217#[doc(inline)]
218#[cfg(all(feature = "__sqlite-shared", feature = "postgres_backend"))]
219#[allow(unreachable_pub)]
220pub use crate::sqlite::expression::helper_types::*;
221
222#[cfg(any(feature = "postgres_backend", feature = "__sqlite-shared"))]
224pub type RetrieveAsText<Lhs, Rhs> = Grouped<
225 crate::expression::operators::RetrieveAsTextJson<
226 Lhs,
227 AsExprOf<
228 <Rhs as JsonIndex>::Expression,
229 <<Rhs as JsonIndex>::Expression as Expression>::SqlType,
230 >,
231 >,
232>;
233
234pub type Collate<Lhs, Col> = Grouped<super::operators::Collate<Lhs, Col>>;