use super::array_comparison::{AsInExpression, In, NotIn};
use super::grouped::Grouped;
use super::select_by::SelectBy;
use super::{AsExpression, Expression};
use crate::expression;
use crate::expression_methods::PreferredBoolSqlType;
use crate::sql_types;
pub type SqlTypeOf<Expr> = <Expr as Expression>::SqlType;
pub type AsExpr<Item, TargetExpr> = AsExprOf<Item, SqlTypeOf<TargetExpr>>;
pub type AsExprOf<Item, Type> = <Item as AsExpression<Type>>::Expression;
pub type Eq<Lhs, Rhs> = Grouped<super::operators::Eq<Lhs, AsExpr<Rhs, Lhs>>>;
pub type NotEq<Lhs, Rhs> = Grouped<super::operators::NotEq<Lhs, AsExpr<Rhs, Lhs>>>;
#[doc(hidden)] pub type Ne<Lhs, Rhs> = NotEq<Lhs, Rhs>;
pub type EqAny<Lhs, Rhs> = Grouped<In<Lhs, <Rhs as AsInExpression<SqlTypeOf<Lhs>>>::InExpression>>;
pub type NeAny<Lhs, Rhs> =
Grouped<NotIn<Lhs, <Rhs as AsInExpression<SqlTypeOf<Lhs>>>::InExpression>>;
#[doc(hidden)] pub type NeAll<Lhs, Rhs> = NeAny<Lhs, Rhs>;
pub type IsNull<Expr> = Grouped<super::operators::IsNull<Expr>>;
pub type IsNotNull<Expr> = Grouped<super::operators::IsNotNull<Expr>>;
pub type Gt<Lhs, Rhs> = Grouped<super::operators::Gt<Lhs, AsExpr<Rhs, Lhs>>>;
pub type GtEq<Lhs, Rhs> = Grouped<super::operators::GtEq<Lhs, AsExpr<Rhs, Lhs>>>;
#[doc(hidden)] pub type Ge<Lhs, Rhs> = GtEq<Lhs, Rhs>;
pub type Lt<Lhs, Rhs> = Grouped<super::operators::Lt<Lhs, AsExpr<Rhs, Lhs>>>;
pub type LtEq<Lhs, Rhs> = Grouped<super::operators::LtEq<Lhs, AsExpr<Rhs, Lhs>>>;
#[doc(hidden)] pub type Le<Lhs, Rhs> = LtEq<Lhs, Rhs>;
pub type Between<Lhs, Lower, Upper> = Grouped<
super::operators::Between<Lhs, super::operators::And<AsExpr<Lower, Lhs>, AsExpr<Upper, Lhs>>>,
>;
pub type NotBetween<Lhs, Lower, Upper> = Grouped<
super::operators::NotBetween<
Lhs,
super::operators::And<AsExpr<Lower, Lhs>, AsExpr<Upper, Lhs>>,
>,
>;
pub type Concat<Lhs, Rhs> = Grouped<super::operators::Concat<Lhs, AsExpr<Rhs, Lhs>>>;
pub type Cast<Expr, ST> = super::cast::Cast<Expr, ST>;
pub type Desc<Expr> = super::operators::Desc<Expr>;
pub type Asc<Expr> = super::operators::Asc<Expr>;
pub type Nullable<Expr> = super::nullable::Nullable<Expr>;
pub type AssumeNotNull<Expr> = super::assume_not_null::AssumeNotNull<Expr>;
pub type And<Lhs, Rhs, ST = <Rhs as PreferredBoolSqlType>::PreferredSqlType> =
Grouped<super::operators::And<Lhs, AsExprOf<Rhs, ST>>>;
pub type Or<Lhs, Rhs, ST = <Rhs as PreferredBoolSqlType>::PreferredSqlType> =
Grouped<super::operators::Or<Lhs, AsExprOf<Rhs, ST>>>;
pub type Escape<Lhs> = Grouped<
super::operators::Escape<
<Lhs as crate::expression_methods::EscapeExpressionMethods>::TextExpression,
AsExprOf<String, sql_types::VarChar>,
>,
>;
pub type Like<Lhs, Rhs> = Grouped<super::operators::Like<Lhs, AsExprOf<Rhs, SqlTypeOf<Lhs>>>>;
pub type NotLike<Lhs, Rhs> = Grouped<super::operators::NotLike<Lhs, AsExprOf<Rhs, SqlTypeOf<Lhs>>>>;
#[allow(non_camel_case_types)] pub type case_when<C, T, ST = <T as Expression>::SqlType> = expression::case_when::CaseWhen<
expression::case_when::CaseWhenConditionsLeaf<Grouped<C>, Grouped<AsExprOf<T, ST>>>,
expression::case_when::NoElseExpression,
>;
pub type When<W, C, T> = expression::case_when::CaseWhen<
expression::case_when::CaseWhenConditionsIntermediateNode<
Grouped<C>,
Grouped<AsExprOf<T, <W as expression::case_when::CaseWhenTypesExtractor>::OutputExpressionSpecifiedSqlType>>,
<W as expression::case_when::CaseWhenTypesExtractor>::Whens,
>,
<W as expression::case_when::CaseWhenTypesExtractor>::Else,
>;
pub type Otherwise<W, E> = expression::case_when::CaseWhen<
<W as expression::case_when::CaseWhenTypesExtractor>::Whens,
expression::case_when::ElseExpression<Grouped<AsExprOf<E, <W as expression::case_when::CaseWhenTypesExtractor>::OutputExpressionSpecifiedSqlType>>>,
>;
pub type AsSelect<Source, DB> = SelectBy<Source, DB>;
pub type IntoSql<Item, SqlType> = AsExprOf<Item, SqlType>;
pub type Field<Alias, Field> = Fields<Alias, Field>;
pub type Fields<Alias, Fields> = <Fields as crate::query_source::aliasing::FieldAliasMapper<
<Alias as crate::query_source::aliasing::GetAliasSourceFromAlias>::Source,
>>::Out;
pub type Add<L, R> = <L as ::core::ops::Add<R>>::Output;
pub type Sub<L, R> = <L as ::core::ops::Sub<R>>::Output;
pub type Mul<L, R> = <L as ::core::ops::Mul<R>>::Output;
pub type Div<L, R> = <L as ::core::ops::Div<R>>::Output;
#[doc(inline)]
#[allow(unreachable_pub)]
pub use super::functions::helper_types::*;
#[doc(inline)]
#[cfg(feature = "postgres_backend")]
#[allow(unreachable_pub)]
pub use crate::pg::expression::helper_types::*;
#[doc(inline)]
#[cfg(feature = "sqlite")]
#[allow(unreachable_pub)]
pub use crate::sqlite::expression::helper_types::*;