Package com.exasol.sql.expression
Class ExpressionTerm
- java.lang.Object
-
- com.exasol.sql.expression.ExpressionTerm
-
public class ExpressionTerm extends Object
Static factory methods for SQL expressions.
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static BooleanLiteral
booleanLiteral(boolean value)
Create a boolean literal.static ColumnReference
column(String column)
Create a reference to a table column.static ColumnReference
column(String table, String column)
Create a reference to a column in a specific table.static BinaryArithmeticExpression
divide(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with DIVIDE operator.static DoubleLiteral
doubleLiteral(double value)
Create a double literal.static FloatLiteral
floatLiteral(float value)
Create a float literal.static Function
function(FunctionName functionName)
Create an Exasol function.static Function
function(FunctionName functionName, ValueExpression... valueExpressions)
Create an Exasol function.static IntegerLiteral
integerLiteral(int value)
Create an integer literal.static LongLiteral
longLiteral(long value)
Create an long literal.static BinaryArithmeticExpression
minus(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with SUBTRACT operator.static BinaryArithmeticExpression
multiply(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with DIVIDE operator.static NullLiteral
nullLiteral()
Create a NULL literal.static BinaryArithmeticExpression
plus(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with ADD operator.static StringLiteral
stringLiteral(char value)
Create a string literal from a character.static StringLiteral
stringLiteral(String value)
Create a string literal.static Function
udf(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)
Create a User Defined Function.static Function
udf(String functionName, ValueExpression... valueExpressions)
Create a User Defined Function.
-
-
-
Method Detail
-
stringLiteral
public static StringLiteral stringLiteral(String value)
Create a string literal.- Parameters:
value
- literal value- Returns:
- string literal
-
stringLiteral
public static StringLiteral stringLiteral(char value)
Create a string literal from a character.- Parameters:
value
- character value- Returns:
- string literal
-
integerLiteral
public static IntegerLiteral integerLiteral(int value)
Create an integer literal.- Parameters:
value
- literal value- Returns:
- integer literal
-
longLiteral
public static LongLiteral longLiteral(long value)
Create an long literal.- Parameters:
value
- literal value- Returns:
- long literal
-
doubleLiteral
public static DoubleLiteral doubleLiteral(double value)
Create a double literal.- Parameters:
value
- literal value- Returns:
- double literal
-
floatLiteral
public static FloatLiteral floatLiteral(float value)
Create a float literal.- Parameters:
value
- literal value- Returns:
- float literal
-
booleanLiteral
public static BooleanLiteral booleanLiteral(boolean value)
Create a boolean literal.- Parameters:
value
- literal value- Returns:
- boolean literal
-
column
public static ColumnReference column(String column)
Create a reference to a table column.- Parameters:
column
- column name- Returns:
- column reference
-
column
public static ColumnReference column(String table, String column)
Create a reference to a column in a specific table.- Parameters:
table
- table namecolumn
- column name- Returns:
- column reference
-
plus
public static BinaryArithmeticExpression plus(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with ADD operator.- Parameters:
left
- left operandright
- right operand- Returns:
- binary arithmetic expression
-
minus
public static BinaryArithmeticExpression minus(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with SUBTRACT operator.- Parameters:
left
- left operandright
- right operand- Returns:
- binary arithmetic expression
-
multiply
public static BinaryArithmeticExpression multiply(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with DIVIDE operator.- Parameters:
left
- left operandright
- right operand- Returns:
- binary arithmetic expression
-
divide
public static BinaryArithmeticExpression divide(ValueExpression left, ValueExpression right)
Create a binary arithmetic expression with DIVIDE operator.- Parameters:
left
- left operandright
- right operand- Returns:
- binary arithmetic expression
-
function
public static Function function(FunctionName functionName)
Create an Exasol function.- Parameters:
functionName
- a name of function- Returns:
- function
-
function
public static Function function(FunctionName functionName, ValueExpression... valueExpressions)
Create an Exasol function.- Parameters:
functionName
- a name of functionvalueExpressions
- zero or more value expressions- Returns:
this
instance for fluent programming
-
udf
public static Function udf(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)
Create a User Defined Function.- Parameters:
functionName
- a name of functionemitsColumnsDefinition
- column definitions for emitsvalueExpressions
- zero or more value expressions- Returns:
- UDF
-
udf
public static Function udf(String functionName, ValueExpression... valueExpressions)
Create a User Defined Function.- Parameters:
functionName
- a name of functionvalueExpressions
- zero or more value expressions- Returns:
- UDF
-
nullLiteral
public static NullLiteral nullLiteral()
Create a NULL literal.- Returns:
- NULL literal
-
-