SqlBuilder (MyBatis Dynamic SQL 1.1.1 API)

```
public interface SqlBuilder
```

Method Summary

All Methods Static Methods Default Methods
Modifier and Type	Method and Description
`static <T extends Number> Add<T>`	`add(BindableColumn<T> firstColumn, BasicColumn secondColumn, BasicColumn... subsequentColumns)`
`static JoinCriterion`	`and(BasicColumn joinColumn, JoinCondition joinCondition)`
`static <T> SqlCriterion<T>`	`and(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> SqlCriterion<T>`	`and(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`
`static Avg`	`avg(BasicColumn column)`
`static Constant`	`constant(String constant)`
`static CountAll`	`count()`
`static Count`	`count(BasicColumn column)`
`static DeleteDSL<DeleteModel>`	`deleteFrom(SqlTable table)`
`static <T extends Number> Divide<T>`	`divide(BindableColumn<T> firstColumn, BasicColumn secondColumn, BasicColumn... subsequentColumns)`
`static EqualTo`	`equalTo(BasicColumn column)`
`static <T> BatchInsertDSL.IntoGatherer<T>`	`insert(List<T> records)`
`static <T> BatchInsertDSL.IntoGatherer<T>`	`insert(T... records)`
`static <T> InsertDSL.IntoGatherer<T>`	`insert(T record)`
`static InsertSelectDSL.InsertColumnGatherer`	`insertInto(SqlTable table)`
`static <T> IsBetween.Builder<T>`	`isBetween(Supplier<T> valueSupplier1)`
`static <T> IsBetween.Builder<T>`	`isBetween(T value1)`
`static <T> IsBetweenWhenPresent.Builder<T>`	`isBetweenWhenPresent(Supplier<T> valueSupplier1)`
`static <T> IsBetweenWhenPresent.Builder<T>`	`isBetweenWhenPresent(T value1)`
`static <T> IsEqualToColumn<T>`	`isEqualTo(BasicColumn column)`
`static <T> IsEqualToWithSubselect<T>`	`isEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsEqualTo<T>`	`isEqualTo(Supplier<T> valueSupplier)`
`static <T> IsEqualTo<T>`	`isEqualTo(T value)`
`static <T> IsEqualToWhenPresent<T>`	`isEqualToWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsEqualToWhenPresent<T>`	`isEqualToWhenPresent(T value)`
`static <T> IsGreaterThanColumn<T>`	`isGreaterThan(BasicColumn column)`
`static <T> IsGreaterThanWithSubselect<T>`	`isGreaterThan(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsGreaterThan<T>`	`isGreaterThan(Supplier<T> valueSupplier)`
`static <T> IsGreaterThan<T>`	`isGreaterThan(T value)`
`static <T> IsGreaterThanOrEqualToColumn<T>`	`isGreaterThanOrEqualTo(BasicColumn column)`
`static <T> IsGreaterThanOrEqualToWithSubselect<T>`	`isGreaterThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsGreaterThanOrEqualTo<T>`	`isGreaterThanOrEqualTo(Supplier<T> valueSupplier)`
`static <T> IsGreaterThanOrEqualTo<T>`	`isGreaterThanOrEqualTo(T value)`
`static <T> IsGreaterThanOrEqualToWhenPresent<T>`	`isGreaterThanOrEqualToWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsGreaterThanOrEqualToWhenPresent<T>`	`isGreaterThanOrEqualToWhenPresent(T value)`
`static <T> IsGreaterThanWhenPresent<T>`	`isGreaterThanWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsGreaterThanWhenPresent<T>`	`isGreaterThanWhenPresent(T value)`
`static <T> IsInWithSubselect<T>`	`isIn(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsIn<T>`	`isIn(List<T> values)`
`static <T> IsIn<T>`	`isIn(T... values)`
`static IsInCaseInsensitive`	`isInCaseInsensitive(List<String> values)`
`static IsInCaseInsensitive`	`isInCaseInsensitive(String... values)`
`static IsInCaseInsensitiveWhenPresent`	`isInCaseInsensitiveWhenPresent(List<String> values)`
`static IsInCaseInsensitiveWhenPresent`	`isInCaseInsensitiveWhenPresent(String... values)`
`static <T> IsInWhenPresent<T>`	`isInWhenPresent(List<T> values)`
`static <T> IsInWhenPresent<T>`	`isInWhenPresent(T... values)`
`static <T> IsLessThanColumn<T>`	`isLessThan(BasicColumn column)`
`static <T> IsLessThanWithSubselect<T>`	`isLessThan(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsLessThan<T>`	`isLessThan(Supplier<T> valueSupplier)`
`static <T> IsLessThan<T>`	`isLessThan(T value)`
`static <T> IsLessThanOrEqualToColumn<T>`	`isLessThanOrEqualTo(BasicColumn column)`
`static <T> IsLessThanOrEqualToWithSubselect<T>`	`isLessThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsLessThanOrEqualTo<T>`	`isLessThanOrEqualTo(Supplier<T> valueSupplier)`
`static <T> IsLessThanOrEqualTo<T>`	`isLessThanOrEqualTo(T value)`
`static <T> IsLessThanOrEqualToWhenPresent<T>`	`isLessThanOrEqualToWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsLessThanOrEqualToWhenPresent<T>`	`isLessThanOrEqualToWhenPresent(T value)`
`static <T> IsLessThanWhenPresent<T>`	`isLessThanWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsLessThanWhenPresent<T>`	`isLessThanWhenPresent(T value)`
`static <T> IsLike<T>`	`isLike(Supplier<T> valueSupplier)`
`static <T> IsLike<T>`	`isLike(T value)`
`static IsLikeCaseInsensitive`	`isLikeCaseInsensitive(String value)`
`static IsLikeCaseInsensitive`	`isLikeCaseInsensitive(Supplier<String> valueSupplier)`
`static IsLikeCaseInsensitiveWhenPresent`	`isLikeCaseInsensitiveWhenPresent(String value)`
`static IsLikeCaseInsensitiveWhenPresent`	`isLikeCaseInsensitiveWhenPresent(Supplier<String> valueSupplier)`
`static <T> IsLikeWhenPresent<T>`	`isLikeWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsLikeWhenPresent<T>`	`isLikeWhenPresent(T value)`
`static <T> IsNotBetween.Builder<T>`	`isNotBetween(Supplier<T> valueSupplier1)`
`static <T> IsNotBetween.Builder<T>`	`isNotBetween(T value1)`
`static <T> IsNotBetweenWhenPresent.Builder<T>`	`isNotBetweenWhenPresent(Supplier<T> valueSupplier1)`
`static <T> IsNotBetweenWhenPresent.Builder<T>`	`isNotBetweenWhenPresent(T value1)`
`static <T> IsNotEqualToColumn<T>`	`isNotEqualTo(BasicColumn column)`
`static <T> IsNotEqualToWithSubselect<T>`	`isNotEqualTo(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsNotEqualTo<T>`	`isNotEqualTo(Supplier<T> valueSupplier)`
`static <T> IsNotEqualTo<T>`	`isNotEqualTo(T value)`
`static <T> IsNotEqualToWhenPresent<T>`	`isNotEqualToWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsNotEqualToWhenPresent<T>`	`isNotEqualToWhenPresent(T value)`
`static <T> IsNotInWithSubselect<T>`	`isNotIn(Buildable<SelectModel> selectModelBuilder)`
`static <T> IsNotIn<T>`	`isNotIn(List<T> values)`
`static <T> IsNotIn<T>`	`isNotIn(T... values)`
`static IsNotInCaseInsensitive`	`isNotInCaseInsensitive(List<String> values)`
`static IsNotInCaseInsensitive`	`isNotInCaseInsensitive(String... values)`
`static IsNotInCaseInsensitiveWhenPresent`	`isNotInCaseInsensitiveWhenPresent(List<String> values)`
`static IsNotInCaseInsensitiveWhenPresent`	`isNotInCaseInsensitiveWhenPresent(String... values)`
`static <T> IsNotInWhenPresent<T>`	`isNotInWhenPresent(List<T> values)`
`static <T> IsNotInWhenPresent<T>`	`isNotInWhenPresent(T... values)`
`static <T> IsNotLike<T>`	`isNotLike(Supplier<T> valueSupplier)`
`static <T> IsNotLike<T>`	`isNotLike(T value)`
`static IsNotLikeCaseInsensitive`	`isNotLikeCaseInsensitive(String value)`
`static IsNotLikeCaseInsensitive`	`isNotLikeCaseInsensitive(Supplier<String> valueSupplier)`
`static IsNotLikeCaseInsensitiveWhenPresent`	`isNotLikeCaseInsensitiveWhenPresent(String value)`
`static IsNotLikeCaseInsensitiveWhenPresent`	`isNotLikeCaseInsensitiveWhenPresent(Supplier<String> valueSupplier)`
`static <T> IsNotLikeWhenPresent<T>`	`isNotLikeWhenPresent(Supplier<T> valueSupplier)`
`static <T> IsNotLikeWhenPresent<T>`	`isNotLikeWhenPresent(T value)`
`static <T> IsNotNull<T>`	`isNotNull()`
`static <T> IsNull<T>`	`isNull()`
`static Lower`	`lower(BindableColumn<String> column)`
`static Max`	`max(BasicColumn column)`
`static Min`	`min(BasicColumn column)`
`static <T extends Number> Multiply<T>`	`multiply(BindableColumn<T> firstColumn, BasicColumn secondColumn, BasicColumn... subsequentColumns)`
`static <T> SqlCriterion<T>`	`or(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> SqlCriterion<T>`	`or(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`
`static QueryExpressionDSL.FromGatherer<SelectModel>`	`select(BasicColumn... selectList)`
`static QueryExpressionDSL.FromGatherer<SelectModel>`	`selectDistinct(BasicColumn... selectList)`
`static SortSpecification`	`sortColumn(String name)`
`static StringConstant`	`stringConstant(String constant)`
`static Substring`	`substring(BindableColumn<String> column, int offset, int length)`
`static <T extends Number> Subtract<T>`	`subtract(BindableColumn<T> firstColumn, BasicColumn secondColumn, BasicColumn... subsequentColumns)`
`static Sum`	`sum(BasicColumn column)`
`static UpdateDSL<UpdateModel>`	`update(SqlTable table)`
`static Upper`	`upper(BindableColumn<String> column)`
`static <T> WhereDSL`	`where(BindableColumn<T> column, VisitableCondition<T> condition)`
`static <T> WhereDSL`	`where(BindableColumn<T> column, VisitableCondition<T> condition, SqlCriterion<?>... subCriteria)`

Method Detail

deleteFrom

static DeleteDSL<DeleteModel> deleteFrom(SqlTable table)

insert

static <T> InsertDSL.IntoGatherer<T> insert(T record)

insert

@SafeVarargs
static <T> BatchInsertDSL.IntoGatherer<T> insert(T... records)

insert

static <T> BatchInsertDSL.IntoGatherer<T> insert(List<T> records)

insertInto

static InsertSelectDSL.InsertColumnGatherer insertInto(SqlTable table)

select

static QueryExpressionDSL.FromGatherer<SelectModel> select(BasicColumn... selectList)

selectDistinct

static QueryExpressionDSL.FromGatherer<SelectModel> selectDistinct(BasicColumn... selectList)

update

static UpdateDSL<UpdateModel> update(SqlTable table)

where

static <T> WhereDSL where(BindableColumn<T> column,
                          VisitableCondition<T> condition)

where

static <T> WhereDSL where(BindableColumn<T> column,
                          VisitableCondition<T> condition,
                          SqlCriterion<?>... subCriteria)

or

static <T> SqlCriterion<T> or(BindableColumn<T> column,
                              VisitableCondition<T> condition)

or

static <T> SqlCriterion<T> or(BindableColumn<T> column,
                              VisitableCondition<T> condition,
                              SqlCriterion<?>... subCriteria)

and

static <T> SqlCriterion<T> and(BindableColumn<T> column,
                               VisitableCondition<T> condition)

and

static <T> SqlCriterion<T> and(BindableColumn<T> column,
                               VisitableCondition<T> condition,
                               SqlCriterion<?>... subCriteria)

and

static JoinCriterion and(BasicColumn joinColumn,
                         JoinCondition joinCondition)

equalTo

static EqualTo equalTo(BasicColumn column)

count
```
static CountAll count()
```

count

static Count count(BasicColumn column)

max
```
static Max max(BasicColumn column)
```

min
```
static Min min(BasicColumn column)
```

avg
```
static Avg avg(BasicColumn column)
```

sum
```
static Sum sum(BasicColumn column)
```

constant

static Constant constant(String constant)

stringConstant

static StringConstant stringConstant(String constant)

add

@SafeVarargs
static <T extends Number> Add<T> add(BindableColumn<T> firstColumn,
                                                  BasicColumn secondColumn,
                                                  BasicColumn... subsequentColumns)

divide

@SafeVarargs
static <T extends Number> Divide<T> divide(BindableColumn<T> firstColumn,
                                                        BasicColumn secondColumn,
                                                        BasicColumn... subsequentColumns)

multiply

@SafeVarargs
static <T extends Number> Multiply<T> multiply(BindableColumn<T> firstColumn,
                                                            BasicColumn secondColumn,
                                                            BasicColumn... subsequentColumns)

subtract

@SafeVarargs
static <T extends Number> Subtract<T> subtract(BindableColumn<T> firstColumn,
                                                            BasicColumn secondColumn,
                                                            BasicColumn... subsequentColumns)

lower

static Lower lower(BindableColumn<String> column)

substring

static Substring substring(BindableColumn<String> column,
                           int offset,
                           int length)

upper

static Upper upper(BindableColumn<String> column)

isNull
```
static <T> IsNull<T> isNull()
```

isNotNull
```
static <T> IsNotNull<T> isNotNull()
```

isEqualTo

static <T> IsEqualTo<T> isEqualTo(T value)

isEqualTo

static <T> IsEqualTo<T> isEqualTo(Supplier<T> valueSupplier)

isEqualTo

static <T> IsEqualToWithSubselect<T> isEqualTo(Buildable<SelectModel> selectModelBuilder)

isEqualTo

static <T> IsEqualToColumn<T> isEqualTo(BasicColumn column)

isEqualToWhenPresent

static <T> IsEqualToWhenPresent<T> isEqualToWhenPresent(T value)

isEqualToWhenPresent

static <T> IsEqualToWhenPresent<T> isEqualToWhenPresent(Supplier<T> valueSupplier)

isNotEqualTo

static <T> IsNotEqualTo<T> isNotEqualTo(T value)

isNotEqualTo

static <T> IsNotEqualTo<T> isNotEqualTo(Supplier<T> valueSupplier)

isNotEqualTo

static <T> IsNotEqualToWithSubselect<T> isNotEqualTo(Buildable<SelectModel> selectModelBuilder)

isNotEqualTo

static <T> IsNotEqualToColumn<T> isNotEqualTo(BasicColumn column)

isNotEqualToWhenPresent

static <T> IsNotEqualToWhenPresent<T> isNotEqualToWhenPresent(T value)

isNotEqualToWhenPresent

static <T> IsNotEqualToWhenPresent<T> isNotEqualToWhenPresent(Supplier<T> valueSupplier)

isGreaterThan

static <T> IsGreaterThan<T> isGreaterThan(T value)

isGreaterThan

static <T> IsGreaterThan<T> isGreaterThan(Supplier<T> valueSupplier)

isGreaterThan

static <T> IsGreaterThanWithSubselect<T> isGreaterThan(Buildable<SelectModel> selectModelBuilder)

isGreaterThan

static <T> IsGreaterThanColumn<T> isGreaterThan(BasicColumn column)

isGreaterThanWhenPresent

static <T> IsGreaterThanWhenPresent<T> isGreaterThanWhenPresent(T value)

isGreaterThanWhenPresent

static <T> IsGreaterThanWhenPresent<T> isGreaterThanWhenPresent(Supplier<T> valueSupplier)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualTo<T> isGreaterThanOrEqualTo(T value)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualTo<T> isGreaterThanOrEqualTo(Supplier<T> valueSupplier)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualToWithSubselect<T> isGreaterThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)

isGreaterThanOrEqualTo

static <T> IsGreaterThanOrEqualToColumn<T> isGreaterThanOrEqualTo(BasicColumn column)

isGreaterThanOrEqualToWhenPresent

static <T> IsGreaterThanOrEqualToWhenPresent<T> isGreaterThanOrEqualToWhenPresent(T value)

isGreaterThanOrEqualToWhenPresent

static <T> IsGreaterThanOrEqualToWhenPresent<T> isGreaterThanOrEqualToWhenPresent(Supplier<T> valueSupplier)

isLessThan

static <T> IsLessThan<T> isLessThan(T value)

isLessThan

static <T> IsLessThan<T> isLessThan(Supplier<T> valueSupplier)

isLessThan

static <T> IsLessThanWithSubselect<T> isLessThan(Buildable<SelectModel> selectModelBuilder)

isLessThan

static <T> IsLessThanColumn<T> isLessThan(BasicColumn column)

isLessThanWhenPresent

static <T> IsLessThanWhenPresent<T> isLessThanWhenPresent(T value)

isLessThanWhenPresent

static <T> IsLessThanWhenPresent<T> isLessThanWhenPresent(Supplier<T> valueSupplier)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualTo<T> isLessThanOrEqualTo(T value)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualTo<T> isLessThanOrEqualTo(Supplier<T> valueSupplier)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualToWithSubselect<T> isLessThanOrEqualTo(Buildable<SelectModel> selectModelBuilder)

isLessThanOrEqualTo

static <T> IsLessThanOrEqualToColumn<T> isLessThanOrEqualTo(BasicColumn column)

isLessThanOrEqualToWhenPresent

static <T> IsLessThanOrEqualToWhenPresent<T> isLessThanOrEqualToWhenPresent(T value)

isLessThanOrEqualToWhenPresent

static <T> IsLessThanOrEqualToWhenPresent<T> isLessThanOrEqualToWhenPresent(Supplier<T> valueSupplier)

isIn

@SafeVarargs
static <T> IsIn<T> isIn(T... values)

isIn

static <T> IsIn<T> isIn(List<T> values)

isIn

static <T> IsInWithSubselect<T> isIn(Buildable<SelectModel> selectModelBuilder)

isInWhenPresent

@SafeVarargs
static <T> IsInWhenPresent<T> isInWhenPresent(T... values)

isInWhenPresent

static <T> IsInWhenPresent<T> isInWhenPresent(List<T> values)

isNotIn

@SafeVarargs
static <T> IsNotIn<T> isNotIn(T... values)

isNotIn

static <T> IsNotIn<T> isNotIn(List<T> values)

isNotIn

static <T> IsNotInWithSubselect<T> isNotIn(Buildable<SelectModel> selectModelBuilder)

isNotInWhenPresent

@SafeVarargs
static <T> IsNotInWhenPresent<T> isNotInWhenPresent(T... values)

isNotInWhenPresent

static <T> IsNotInWhenPresent<T> isNotInWhenPresent(List<T> values)

isBetween

static <T> IsBetween.Builder<T> isBetween(T value1)

isBetween

static <T> IsBetween.Builder<T> isBetween(Supplier<T> valueSupplier1)

isBetweenWhenPresent

static <T> IsBetweenWhenPresent.Builder<T> isBetweenWhenPresent(T value1)

isBetweenWhenPresent

static <T> IsBetweenWhenPresent.Builder<T> isBetweenWhenPresent(Supplier<T> valueSupplier1)

isNotBetween

static <T> IsNotBetween.Builder<T> isNotBetween(T value1)

isNotBetween

static <T> IsNotBetween.Builder<T> isNotBetween(Supplier<T> valueSupplier1)

isNotBetweenWhenPresent

static <T> IsNotBetweenWhenPresent.Builder<T> isNotBetweenWhenPresent(T value1)

isNotBetweenWhenPresent

static <T> IsNotBetweenWhenPresent.Builder<T> isNotBetweenWhenPresent(Supplier<T> valueSupplier1)

isLike

static <T> IsLike<T> isLike(T value)

isLike

static <T> IsLike<T> isLike(Supplier<T> valueSupplier)

isLikeWhenPresent

static <T> IsLikeWhenPresent<T> isLikeWhenPresent(T value)

isLikeWhenPresent

static <T> IsLikeWhenPresent<T> isLikeWhenPresent(Supplier<T> valueSupplier)

isNotLike

static <T> IsNotLike<T> isNotLike(T value)

isNotLike

static <T> IsNotLike<T> isNotLike(Supplier<T> valueSupplier)

isNotLikeWhenPresent

static <T> IsNotLikeWhenPresent<T> isNotLikeWhenPresent(T value)

isNotLikeWhenPresent

static <T> IsNotLikeWhenPresent<T> isNotLikeWhenPresent(Supplier<T> valueSupplier)

isLikeCaseInsensitive

static IsLikeCaseInsensitive isLikeCaseInsensitive(String value)

isLikeCaseInsensitive

static IsLikeCaseInsensitive isLikeCaseInsensitive(Supplier<String> valueSupplier)

isLikeCaseInsensitiveWhenPresent

static IsLikeCaseInsensitiveWhenPresent isLikeCaseInsensitiveWhenPresent(String value)

isLikeCaseInsensitiveWhenPresent

static IsLikeCaseInsensitiveWhenPresent isLikeCaseInsensitiveWhenPresent(Supplier<String> valueSupplier)

isNotLikeCaseInsensitive

static IsNotLikeCaseInsensitive isNotLikeCaseInsensitive(String value)

isNotLikeCaseInsensitive

static IsNotLikeCaseInsensitive isNotLikeCaseInsensitive(Supplier<String> valueSupplier)

isNotLikeCaseInsensitiveWhenPresent

static IsNotLikeCaseInsensitiveWhenPresent isNotLikeCaseInsensitiveWhenPresent(String value)

isNotLikeCaseInsensitiveWhenPresent

static IsNotLikeCaseInsensitiveWhenPresent isNotLikeCaseInsensitiveWhenPresent(Supplier<String> valueSupplier)

isInCaseInsensitive

static IsInCaseInsensitive isInCaseInsensitive(String... values)

isInCaseInsensitive

static IsInCaseInsensitive isInCaseInsensitive(List<String> values)

isInCaseInsensitiveWhenPresent

static IsInCaseInsensitiveWhenPresent isInCaseInsensitiveWhenPresent(String... values)

isInCaseInsensitiveWhenPresent

static IsInCaseInsensitiveWhenPresent isInCaseInsensitiveWhenPresent(List<String> values)

isNotInCaseInsensitive

static IsNotInCaseInsensitive isNotInCaseInsensitive(String... values)

isNotInCaseInsensitive

static IsNotInCaseInsensitive isNotInCaseInsensitive(List<String> values)

isNotInCaseInsensitiveWhenPresent

static IsNotInCaseInsensitiveWhenPresent isNotInCaseInsensitiveWhenPresent(String... values)

isNotInCaseInsensitiveWhenPresent

static IsNotInCaseInsensitiveWhenPresent isNotInCaseInsensitiveWhenPresent(List<String> values)

sortColumn

static SortSpecification sortColumn(String name)

Interface SqlBuilder

Method Summary

Method Detail

deleteFrom

insert

insert

insert

insertInto

select

selectDistinct

update

where

where

or

or

and

and

and

equalTo

count

count

max

min

avg

sum

constant

stringConstant

add

divide

multiply

subtract

lower

substring

upper

isNull

isNotNull

isEqualTo

isEqualTo

isEqualTo

isEqualTo

isEqualToWhenPresent

isEqualToWhenPresent

isNotEqualTo

isNotEqualTo

isNotEqualTo

isNotEqualTo

isNotEqualToWhenPresent

isNotEqualToWhenPresent

isGreaterThan

isGreaterThan

isGreaterThan

isGreaterThan

isGreaterThanWhenPresent

isGreaterThanWhenPresent

isGreaterThanOrEqualTo

isGreaterThanOrEqualTo

isGreaterThanOrEqualTo

isGreaterThanOrEqualTo

isGreaterThanOrEqualToWhenPresent

isGreaterThanOrEqualToWhenPresent

isLessThan

isLessThan

isLessThan

isLessThan

isLessThanWhenPresent

isLessThanWhenPresent

isLessThanOrEqualTo

isLessThanOrEqualTo

isLessThanOrEqualTo

isLessThanOrEqualTo

isLessThanOrEqualToWhenPresent

isLessThanOrEqualToWhenPresent

isIn

isIn

isIn

isInWhenPresent

isInWhenPresent

isNotIn

isNotIn

isNotIn