Package com.couchbase.client.java.query.dsl

Class Expression

java.lang.Object
com.couchbase.client.java.query.dsl.Expression
public class Expression
extends Object
Represents a N1QL Expression.
Since:
2.0.0
Author:
Michael Nitschinger

  • Method Summary

    Modifier and Type Method Description
    Expression add​(Expression expression)
    Arithmetic addition between current and given expression.
    Expression add​(Number b)
    Arithmetic addition between current expression and a given number.
    Expression add​(String expression)
    Arithmetic addition between current and given expression.
    Expression and​(boolean right)
    AND-combines two expressions.
    Expression and​(double right)
    AND-combines two expressions.
    Expression and​(float right)
    AND-combines two expressions.
    Expression and​(int right)
    AND-combines two expressions.
    Expression and​(long right)
    AND-combines two expressions.
    Expression and​(JsonArray right)
    AND-combines two expressions.
    Expression and​(JsonObject right)
    AND-combines two expressions.
    Expression and​(Expression right)
    AND-combines two expressions.
    Expression and​(String right)
    AND-combines two expressions.
    Expression as​(Expression alias)
    Adds a AS clause between the current and the given expression.
    Expression as​(String alias)
    Adds a AS clause between the current and the given expression.
    Expression between​(boolean right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(double right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(float right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(int right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(long right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(JsonArray right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(JsonObject right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(Expression right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression between​(String right)
    Adds a BETWEEN clause between the current and the given expression.
    Expression concat​(boolean right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(double right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(float right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(int right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(long right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(JsonArray right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(JsonObject right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(Expression right)
    Combines two expressions with the concatenation operator ("||").
    Expression concat​(String right)
    Combines two expressions with the concatenation operator ("||").
    Expression divide​(Expression expression)
    Arithmetic division between current and given expression.
    Expression divide​(Number b)
    Arithmetic division between current expression and a given number.
    Expression divide​(String expression)
    Arithmetic division between current and given expression.
    Expression eq​(boolean right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(double right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(float right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(int right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(long right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(JsonArray right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(JsonObject right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(Expression right)
    Combines two expressions with the equals operator ("=").
    Expression eq​(String right)
    Combines two expressions with the equals operator ("=").
    Expression exists()
    Prefixes the current expression with the EXISTS clause.
    static Expression FALSE()
    Returns an expression representing boolean FALSE.
    Expression get​(Expression expression)
    Get attribute of an object using the given expression as attribute name.
    Expression get​(String expression)
    Get attribute of an object using the given string as attribute name.
    Expression gt​(boolean right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(double right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(float right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(int right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(long right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(JsonArray right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(JsonObject right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(Expression right)
    Combines two expressions with the greater than operator (">").
    Expression gt​(String right)
    Combines two expressions with the greater than operator (">").
    Expression gte​(boolean right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(double right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(float right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(int right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(long right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(JsonArray right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(JsonObject right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(Expression right)
    Combines two expressions with the greater or equals than operator (">=").
    Expression gte​(String right)
    Combines two expressions with the greater or equals than operator (">=").
    static Expression i​(String... identifiers)
    An identifier or list of identifiers escaped using backquotes `.
    Expression in​(boolean right)
    Adds a IN clause between the current and the given expression.
    Expression in​(double right)
    Adds a IN clause between the current and the given expression.
    Expression in​(float right)
    Adds a IN clause between the current and the given expression.
    Expression in​(int right)
    Adds a IN clause between the current and the given expression.
    Expression in​(long right)
    Adds a IN clause between the current and the given expression.
    Expression in​(JsonArray right)
    Adds a IN clause between the current and the given expression.
    Expression in​(JsonObject right)
    Adds a IN clause between the current and the given expression.
    Expression in​(Expression right)
    Adds a IN clause between the current and the given expression.
    Expression in​(String right)
    Adds a IN clause between the current and the given expression.
    Expression isMissing()
    Appends a "IS MISSING" to the expression.
    Expression isNotMissing()
    Appends a "IS NOT MISSING" to the expression.
    Expression isNotNull()
    Appends a "IS NOT NULL" to the expression.
    Expression isNotValued()
    Appends a "IS NOT VALUED" to the expression.
    Expression isNull()
    Appends a "IS NULL" to the expression.
    Expression isValued()
    Appends a "IS VALUED" to the expression.
    Expression like​(boolean right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(double right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(float right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(int right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(long right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(JsonArray right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(JsonObject right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(Expression right)
    Adds a LIKE clause between the current and the given expression.
    Expression like​(String right)
    Adds a LIKE clause between the current and the given expression.
    Expression lt​(boolean right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(double right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(float right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(int right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(long right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(JsonArray right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(JsonObject right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(Expression right)
    Combines two expressions with the less than operator ("<").
    Expression lt​(String right)
    Combines two expressions with the less than operator ("<").
    Expression lte​(boolean right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(double right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(float right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(int right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(long right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(JsonArray right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(JsonObject right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(Expression right)
    Combines two expressions with the less or equals than operator ("<=").
    Expression lte​(String right)
    Combines two expressions with the less or equals than operator ("<=").
    static Expression MISSING()
    Returns an expression representing MISSING.
    Expression multiply​(Expression expression)
    Arithmetic multiplication between current and given expression.
    Expression multiply​(Number b)
    Arithmetic multiplication between current expression and a given number.
    Expression multiply​(String expression)
    Arithmetic multiplication between current and given expression.
    Expression ne​(double right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(float right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(int right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(long right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(JsonArray right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(JsonObject right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(Expression right)
    Combines two expressions with the not equals operator ("!=").
    Expression ne​(String right)
    Combines two expressions with the not equals operator ("!=").
    Expression not()
    Negates the given expression by prefixing a NOT.
    Expression notBetween​(boolean right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(double right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(float right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(int right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(long right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(JsonArray right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(JsonObject right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(Expression right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notBetween​(String right)
    Adds a NOT BETWEEN clause between the current and the given expression.
    Expression notIn​(boolean right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(double right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(float right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(int right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(long right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(JsonArray right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(JsonObject right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(Expression right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notIn​(String right)
    Adds a NOT IN clause between the current and the given expression.
    Expression notLike​(boolean right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(double right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(float right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(int right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(long right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(JsonArray right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(JsonObject right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(Expression right)
    Adds a NOT LIKE clause between the current and the given expression.
    Expression notLike​(String right)
    Adds a NOT LIKE clause between the current and the given expression.
    static Expression NULL()
    Returns an expression representing NULL.
    Expression or​(boolean right)
    OR-combines two expressions.
    Expression or​(double right)
    OR-combines two expressions.
    Expression or​(float right)
    OR-combines two expressions.
    Expression or​(int right)
    OR-combines two expressions.
    Expression or​(long right)
    OR-combines two expressions.
    Expression or​(JsonArray right)
    OR-combines two expressions.
    Expression or​(JsonObject right)
    OR-combines two expressions.
    Expression or​(Expression right)
    OR-combines two expressions.
    Expression or​(String right)
    OR-combines two expressions.
    static Expression par​(Expression expression)
    Puts an Expression in parenthesis.
    static Expression path​(Object... pathComponents)
    Construct a path ("a.b.c") from Expressions or values.
    static Expression s​(String... strings)
    An identifier or list of identifiers which will be quoted as strings (with "").
    static Expression sub​(Statement statement)
    Creates an expression from a given sub-Statement, wrapping it in parenthesis.
    Expression subtract​(Expression expression)
    Arithmetic v between current and given expression.
    Expression subtract​(Number b)
    Arithmetic subtraction between current expression and a given number.
    Expression subtract​(String expression)
    Arithmetic subtraction between current and given expression.
    String toString()  
    static Expression TRUE()
    Returns an expression representing boolean TRUE.
    static Expression x​(boolean value)
    Creates an arbitrary expression from the given boolean value.
    static Expression x​(double value)
    Creates an arbitrary expression from the given double value.
    static Expression x​(float value)
    Creates an arbitrary expression from the given float value.
    static Expression x​(int value)
    Creates an arbitrary expression from the given integer value.
    static Expression x​(long value)
    Creates an arbitrary expression from the given long value.
    static Expression x​(JsonArray value)
    Creates an arbitrary expression from the given json array.
    static Expression x​(JsonObject value)
    Creates an arbitrary expression from the given json object.
    static Expression x​(Statement statement)
    Creates an expression for a given Statement, as is.
    static Expression x​(Number number)
    Creates an expression from a Number, as is.
    static Expression x​(String value)
    Creates an arbitrary expression from the given string value.

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

  • Method Details

    • x

      public static Expression x​(String value)
      Creates an arbitrary expression from the given string value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(int value)
      Creates an arbitrary expression from the given integer value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(long value)
      Creates an arbitrary expression from the given long value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(boolean value)
      Creates an arbitrary expression from the given boolean value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(double value)
      Creates an arbitrary expression from the given double value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(float value)
      Creates an arbitrary expression from the given float value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(JsonArray value)
      Creates an arbitrary expression from the given json array. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(JsonObject value)
      Creates an arbitrary expression from the given json object. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.
      Parameters:
      value - the value to create the expression from.
      Returns:
      a new Expression representing the value.

    • x

      public static Expression x​(Statement statement)
      Creates an expression for a given Statement, as is.
      Parameters:
      statement - the statement to convert to an expression.
      Returns:
      the statement, converted as is into an expression.

    • x

      public static Expression x​(Number number)
      Creates an expression from a Number, as is.
      Parameters:
      number - the number constant to convert to an expression.
      Returns:
      the number converted into an expression.

    • sub

      public static Expression sub​(Statement statement)
      Creates an expression from a given sub-Statement, wrapping it in parenthesis.
      Parameters:
      statement - the statement to convert to an expression.
      Returns:
      the statement, converted into an expression wrapped in parenthesis.

    • par

      public static Expression par​(Expression expression)
      Puts an Expression in parenthesis.
      Parameters:
      expression - the expression to wrap in parenthesis.
      Returns:
      the expression, wrapped in parenthesis.

    • path

      public static Expression path​(Object... pathComponents)
      Construct a path ("a.b.c") from Expressions or values. Strings are considered identifiers (so they won't be quoted).
      Parameters:
      pathComponents - the elements of the path, joined together by a dot.
      Returns:
      the path created from the given components.

    • i

      public static Expression i​(String... identifiers)
      An identifier or list of identifiers escaped using backquotes `. Useful for example for identifiers that contains a dash like "beer-sample". Multiple identifiers are returned as a list of escaped identifiers separated by ", ".
      Parameters:
      identifiers - the identifier(s) to escape.
      Returns:
      an Expression representing the escaped identifier.

    • s

      public static Expression s​(String... strings)
      An identifier or list of identifiers which will be quoted as strings (with "").
      Parameters:
      strings - the list of strings to quote.
      Returns:
      an Expression representing the quoted strings.

    • TRUE

      public static Expression TRUE()
      Returns an expression representing boolean TRUE.
      Returns:
      an expression representing TRUE.

    • FALSE

      public static Expression FALSE()
      Returns an expression representing boolean FALSE.
      Returns:
      an expression representing FALSE.

    • NULL

      public static Expression NULL()
      Returns an expression representing NULL.
      Returns:
      an expression representing NULL.

    • MISSING

      public static Expression MISSING()
      Returns an expression representing MISSING.
      Returns:
      an expression representing MISSING.

    • not

      public Expression not()
      Negates the given expression by prefixing a NOT.
      Returns:
      the negated expression.

    • and

      public Expression and​(Expression right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(String right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(int right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(long right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(float right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(double right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(boolean right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(JsonObject right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • and

      public Expression and​(JsonArray right)
      AND-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(Expression right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(String right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(int right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(long right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(boolean right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(float right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(double right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(JsonArray right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • or

      public Expression or​(JsonObject right)
      OR-combines two expressions.
      Parameters:
      right - the expression to combine with the current one.
      Returns:
      a combined expression.

    • eq

      public Expression eq​(Expression right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(String right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(int right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(long right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(float right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(double right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(boolean right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(JsonArray right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • eq

      public Expression eq​(JsonObject right)
      Combines two expressions with the equals operator ("=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(Expression right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(String right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(int right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(long right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(double right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(float right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(JsonObject right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • ne

      public Expression ne​(JsonArray right)
      Combines two expressions with the not equals operator ("!=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(Expression right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(String right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(int right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(long right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(float right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(double right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(boolean right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(JsonArray right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gt

      public Expression gt​(JsonObject right)
      Combines two expressions with the greater than operator (">").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(Expression right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(String right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(int right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(long right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(double right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(float right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(boolean right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(JsonObject right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lt

      public Expression lt​(JsonArray right)
      Combines two expressions with the less than operator ("<").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(Expression right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(String right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(int right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(long right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(double right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(float right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(boolean right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(JsonObject right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • gte

      public Expression gte​(JsonArray right)
      Combines two expressions with the greater or equals than operator (">=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(Expression right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(String right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(int right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(long right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(boolean right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(float right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(double right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(JsonObject right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • concat

      public Expression concat​(JsonArray right)
      Combines two expressions with the concatenation operator ("||").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(Expression right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(String right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(int right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(long right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(float right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(double right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(boolean right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(JsonObject right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • lte

      public Expression lte​(JsonArray right)
      Combines two expressions with the less or equals than operator ("<=").
      Parameters:
      right - the expression to combine.
      Returns:
      the combined expressions.

    • isValued

      public Expression isValued()
      Appends a "IS VALUED" to the expression.
      Returns:
      the postfixed expression.

    • isNotValued

      public Expression isNotValued()
      Appends a "IS NOT VALUED" to the expression.
      Returns:
      the postfixed expression.

    • isNull

      public Expression isNull()
      Appends a "IS NULL" to the expression.
      Returns:
      the postfixed expression.

    • isNotNull

      public Expression isNotNull()
      Appends a "IS NOT NULL" to the expression.
      Returns:
      the postfixed expression.

    • isMissing

      public Expression isMissing()
      Appends a "IS MISSING" to the expression.
      Returns:
      the postfixed expression.

    • isNotMissing

      public Expression isNotMissing()
      Appends a "IS NOT MISSING" to the expression.
      Returns:
      the postfixed expression.

    • between

      public Expression between​(Expression right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(String right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(int right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(long right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(double right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(float right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(boolean right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(JsonObject right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • between

      public Expression between​(JsonArray right)
      Adds a BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(Expression right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(String right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(int right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(long right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(double right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(float right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(boolean right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(JsonObject right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notBetween

      public Expression notBetween​(JsonArray right)
      Adds a NOT BETWEEN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(Expression right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(String right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(int right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(long right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(boolean right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(double right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(float right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(JsonObject right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • like

      public Expression like​(JsonArray right)
      Adds a LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(Expression right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(String right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(int right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(long right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(boolean right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(float right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(double right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(JsonObject right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notLike

      public Expression notLike​(JsonArray right)
      Adds a NOT LIKE clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • exists

      public Expression exists()
      Prefixes the current expression with the EXISTS clause.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(Expression right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(String right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(int right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(long right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(boolean right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(double right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(float right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(JsonObject right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • in

      public Expression in​(JsonArray right)
      Adds a IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(Expression right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(String right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(int right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(long right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(boolean right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(float right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(double right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(JsonObject right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • notIn

      public Expression notIn​(JsonArray right)
      Adds a NOT IN clause between the current and the given expression.
      Parameters:
      right - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • as

      public Expression as​(String alias)
      Adds a AS clause between the current and the given expression. Often used to alias an identifier.
      Parameters:
      alias - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • as

      public Expression as​(Expression alias)
      Adds a AS clause between the current and the given expression. Often used to alias an identifier.
      Parameters:
      alias - the right hand side expression.
      Returns:
      a new expression with the clause applied.

    • add

      public Expression add​(Expression expression)
      Arithmetic addition between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the addition expression.

    • add

      public Expression add​(Number b)
      Arithmetic addition between current expression and a given number.
      Parameters:
      b - the right hand side number.
      Returns:
      the addition expression.

    • add

      public Expression add​(String expression)
      Arithmetic addition between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the addition expression.

    • subtract

      public Expression subtract​(Expression expression)
      Arithmetic v between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the subtraction expression.

    • subtract

      public Expression subtract​(Number b)
      Arithmetic subtraction between current expression and a given number.
      Parameters:
      b - the right hand side number.
      Returns:
      the subtraction expression.

    • subtract

      public Expression subtract​(String expression)
      Arithmetic subtraction between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the subtraction expression.

    • multiply

      public Expression multiply​(Expression expression)
      Arithmetic multiplication between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the multiplication expression.

    • multiply

      public Expression multiply​(Number b)
      Arithmetic multiplication between current expression and a given number.
      Parameters:
      b - the right hand side number.
      Returns:
      the multiplication expression.

    • multiply

      public Expression multiply​(String expression)
      Arithmetic multiplication between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the multiplication expression.

    • divide

      public Expression divide​(Expression expression)
      Arithmetic division between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the division expression.

    • divide

      public Expression divide​(Number b)
      Arithmetic division between current expression and a given number.
      Parameters:
      b - the right hand side number.
      Returns:
      the division expression.

    • divide

      public Expression divide​(String expression)
      Arithmetic division between current and given expression.
      Parameters:
      expression - the right hand side expression.
      Returns:
      the division expression.

    • get

      public Expression get​(String expression)
      Get attribute of an object using the given string as attribute name.
      Parameters:
      expression - The attribute name
      Returns:
      the getter expression

    • get

      public Expression get​(Expression expression)
      Get attribute of an object using the given expression as attribute name.
      Parameters:
      expression - The attribute name
      Returns:
      the getter expression

    • toString

      public String toString()
      Overrides:
      toString in class Object