Uses of Interface
io.github.torand.fastersql.expression.Expression

Packages that use Expression

Package	Description
io.github.torand.fastersql.alias	Provides classes and interfaces related to column and table aliases.
io.github.torand.fastersql.constant	Provides classes and interfaces related to inline value constants for statements.
io.github.torand.fastersql.expression	Provides classes and interfaces related to scalar or tabular expressions.
io.github.torand.fastersql.expression.arithmetic	Provides classes representing arithmetic expressions.
io.github.torand.fastersql.expression.cases	Provides classes representing CASE expressions.
io.github.torand.fastersql.function	Provides classes and interfaces related to aggregate, single row and system functions.
io.github.torand.fastersql.function.aggregate	Provides classes and interfaces related to aggregate functions.
io.github.torand.fastersql.function.singlerow	Provides classes and interfaces related to single row functions.
io.github.torand.fastersql.function.singlerow.cast	Provides classes representing the CAST function.
io.github.torand.fastersql.function.system	Provides classes and interfaces related to system functions.
io.github.torand.fastersql.model	Provides classes representing the database model.
io.github.torand.fastersql.predicate	Provides classes and interfaces related to predicates.
io.github.torand.fastersql.predicate.comparison	Provides classes and interfaces representing comparison predicates.
io.github.torand.fastersql.statement	Provides classes and interfaces related to statements.
io.github.torand.fastersql.subquery	Provides classes and interfaces related to subqueries.

Uses of Expression in io.github.torand.fastersql.alias

Classes in io.github.torand.fastersql.alias that implement Expression

Modifier and Type	Class	Description
class	ColumnRef	References a column using a combination of a table alias and a column alias.

Uses of Expression in io.github.torand.fastersql.constant

Subinterfaces of Expression in io.github.torand.fastersql.constant

Modifier and Type	Interface	Description
interface	Constant	Defines a constant value.

Classes in io.github.torand.fastersql.constant that implement Expression

Modifier and Type	Class	Description
class	GenericConstant<T>	Represents a scalar value constant of any type.
class	InlineNumberConstant	Represents an inline number constant.
class	InlineStringConstant	Represents an inline string constant.
class	NullConstant	Represents the 'null' constant value.

Uses of Expression in io.github.torand.fastersql.expression

Methods in io.github.torand.fastersql.expression that return Expression

Modifier and Type	Method	Description
default Expression	Expression.dividedBy(Expression expression)	Creates the expression of dividing this expression by another expression.
default Expression	Expression.dividedBy(Number value)	Creates the expression of dividing this expression by a constant value.
default Expression	Expression.minus(Expression expression)	Creates the expression of subtracting another expression from this expression.
default Expression	Expression.minus(Number value)	Creates the expression of subtracting a constant value from this expression.
default Expression	Expression.mod(Expression expression)	Creates the expression of calculating the remainder after dividing this expression by another expression.
default Expression	Expression.mod(Number value)	Creates the expression of calculating the remainder after dividing this expression by a constant value.
default Expression	Expression.plus(Expression expression)	Creates the expression of adding another expression to this expression.
default Expression	Expression.plus(Number value)	Creates the expression of adding a constant value to this expression.
default Expression	Expression.times(Expression expression)	Creates the expression of multiplying another expression with this expression.
default Expression	Expression.times(Number value)	Creates the expression of multiplying a constant value with this expression.

Methods in io.github.torand.fastersql.expression with parameters of type Expression

Modifier and Type	Method	Description
default Expression	Expression.dividedBy(Expression expression)	Creates the expression of dividing this expression by another expression.
default Expression	Expression.minus(Expression expression)	Creates the expression of subtracting another expression from this expression.
default Expression	Expression.mod(Expression expression)	Creates the expression of calculating the remainder after dividing this expression by another expression.
default Expression	Expression.plus(Expression expression)	Creates the expression of adding another expression to this expression.
default Expression	Expression.times(Expression expression)	Creates the expression of multiplying another expression with this expression.

Uses of Expression in io.github.torand.fastersql.expression.arithmetic

Classes in io.github.torand.fastersql.expression.arithmetic that implement Expression

Modifier and Type	Class	Description
class	Addition	Implements the addition (sum) expression.
class	Division	Implements the division (quotient) expression.
class	Modulo	Implements the modulo (division remainder) expression.
class	Multiplication	Implements the multiplication (product) expression.
class	Negate	Implements the negate numerical function.
class	Subtraction	Implements the subtraction (difference) expression.

Methods in io.github.torand.fastersql.expression.arithmetic with parameters of type Expression

Modifier and Type	Method	Description
static Addition	ArithmeticExpressions.add(Expression firstTerm, Expression secondTerm)	Creates an addition (sum) expression.
static Division	ArithmeticExpressions.divide(Expression dividend, Expression divisor)	Creates a division (quotient) expression.
static Modulo	ArithmeticExpressions.mod(Expression dividend, Expression divisor)	Creates a modulo (division remainder) expression.
static Multiplication	ArithmeticExpressions.multiply(Expression firstFactor, Expression secondFactor)	Creates a multiplication (product) expression.
static Negate	ArithmeticExpressions.neg(Expression expression)	Creates a negatation expression.
static Subtraction	ArithmeticExpressions.subtract(Expression minuend, Expression subtrahend)	Creates a subtraction (difference) expression.

Uses of Expression in io.github.torand.fastersql.expression.cases

Classes in io.github.torand.fastersql.expression.cases that implement Expression

Modifier and Type	Class	Description
class	SearchedCase	Implements a searched CASE expression.
class	SimpleCase	Implements a simple CASE expression.

Methods in io.github.torand.fastersql.expression.cases with parameters of type Expression

Modifier and Type	Method	Description
static SimpleCaseBuilder	CaseExpressions.case_(Expression caseExpression)	Creates a simple CASE expression.
SearchedCaseBuilder	SearchedCaseBuilder.else_(Expression elseExpression)	Adds an ELSE clause.
SimpleCaseBuilder	SimpleCaseBuilder.else_(Expression elseExpression)	Adds an ELSE clause.
SearchedCaseBuilder	SearchedCaseBuilder.SearchedWhenThenBuilder.then(Expression thenExpression)	Adds a WHEN-THEN clause.
SimpleCaseBuilder	SimpleCaseBuilder.SimpleWhenThenBuilder.then(Expression thenExpression)	Adds a WHEN-THEN clause.
SimpleCaseBuilder.SimpleWhenThenBuilder	SimpleCaseBuilder.when(Expression whenExpression)	Creates a WHEN-THEN clause.

Uses of Expression in io.github.torand.fastersql.function

Subinterfaces of Expression in io.github.torand.fastersql.function

Modifier and Type	Interface	Description
interface	ColumnFunction	Defines a function that operates on a specific column (or no specific column).
interface	Function	Defines a construct that evaluates to a single value, based upon zero, one or multiple rows.

Uses of Expression in io.github.torand.fastersql.function.aggregate

Subinterfaces of Expression in io.github.torand.fastersql.function.aggregate

Modifier and Type	Interface	Description
interface	AggregateFunction	Defines a function that returns a single value based upon a set of other values fetched from multiple rows.

Classes in io.github.torand.fastersql.function.aggregate that implement Expression

Modifier and Type	Class	Description
class	Avg	Implements the average aggregate function.
class	Count	Implements the count aggregate function.
class	CountAll	Implements the count all aggregate function.
class	Max	Implements the maximum aggregate function.
class	Min	Implements the minimum aggregate function.
class	Sum	Implements the sum aggregate function.

Methods in io.github.torand.fastersql.function.aggregate with parameters of type Expression

Modifier and Type	Method	Description
static Avg	AggregateFunctions.avg(Expression expression)	Creates the average aggregate of an expression.
static Count	AggregateFunctions.count(Expression expression)	Creates the count aggregate of an expression.
static Max	AggregateFunctions.max(Expression expression)	Creates the maximum aggregate of an expression.
static Min	AggregateFunctions.min(Expression expression)	Creates the minimum aggregate of an expression.
static Sum	AggregateFunctions.sum(Expression expression)	Creates the sum aggregate of an expression.

Uses of Expression in io.github.torand.fastersql.function.singlerow

Subinterfaces of Expression in io.github.torand.fastersql.function.singlerow

Modifier and Type	Interface	Description
interface	SingleRowFunction	Defines a function that returns a single value based upon one value from a single row.

Classes in io.github.torand.fastersql.function.singlerow that implement Expression

Modifier and Type	Class	Description
class	Abs	Implements the absolute value numeric function.
class	Ceil	Implements the ceiling numeric function.
class	Concat	Implements the concatenation string function.
class	Exp	Implements the natural exponential numeric function.
class	Floor	Implements the floor numeric function.
class	Length	Implements the length string function.
class	Ln	Implements the natural logarithm numeric function.
class	Lower	Implements the lower case string function.
class	Power	Implements the power (exponentiation) numeric function.
class	Round	Implements the round numeric function.
class	Sqrt	Implements the square root numeric function.
class	Substring	Implements the substring string function.
class	ToChar	Implements the timestamp/number to string conversion function.
class	ToNumber	Implements the string to number conversion function.
class	Upper	Implements the upper case string function.

Methods in io.github.torand.fastersql.function.singlerow with parameters of type Expression

Modifier and Type	Method	Description
static Abs	SingleRowFunctions.abs(Expression expression)	Creates the ABS function for a numeric expression.
static CastBuilder	SingleRowFunctions.cast(Expression expression)	Creates the CAST function for an expression.
static Ceil	SingleRowFunctions.ceil(Expression expression)	Creates the CEIL function for a numeric expression.
static Concat	SingleRowFunctions.concat(Expression expression1, Expression expression2, Expression... otherExpressions)	Creates the CONCAT function for two or more string expressions.
static Exp	SingleRowFunctions.exp(Expression expression)	Creates the EXP (natural exponential) function for a numeric expression.
static Floor	SingleRowFunctions.floor(Expression expression)	Creates the FLOOR function for a numeric expression.
static Length	SingleRowFunctions.length(Expression expression)	Creates the LENGTH function for a string expression.
static Ln	SingleRowFunctions.ln(Expression expression)	Creates the LN (natural logarithm) function for a numeric expression.
static Lower	SingleRowFunctions.lower(Expression expression)	Creates the LOWER function for a string expression.
static Power	SingleRowFunctions.pow(Expression base, Expression exponent)	Creates the POW (exponentiation) function for a numeric expression.
static Power	SingleRowFunctions.pow(Expression base, Number exponent)	Creates the POW (exponentiation) function for a numeric expression with constant value exponent.
static Round	SingleRowFunctions.round(Expression expression)	Creates the ROUND function for a numeric expression.
static Sqrt	SingleRowFunctions.sqrt(Expression expression)	Creates the SQRT (square root) function for a numeric expression.
static Substring	SingleRowFunctions.substring(Expression expression, int startPos, int length)	Creates the SUBSTRING function for a string expression.
static ToChar	SingleRowFunctions.toChar(Expression expression, String format)	Creates the TO_CHAR function converting from a timestamp/number expression to string.
static ToNumber	SingleRowFunctions.toNumber(Expression expression, int precision)	Creates the TO_NUMBER function converting from a string expression to integer.
static ToNumber	SingleRowFunctions.toNumber(Expression expression, int precision, int scale)	Creates the TO_NUMBER function converting from a string expression to decimal number.
static Upper	SingleRowFunctions.upper(Expression expression)	Creates the UPPER function for a string expression.

Uses of Expression in io.github.torand.fastersql.function.singlerow.cast

Classes in io.github.torand.fastersql.function.singlerow.cast that implement Expression

Modifier and Type	Class	Description
class	Cast	Implements the cast function.

Constructors in io.github.torand.fastersql.function.singlerow.cast with parameters of type Expression

Modifier	Constructor	Description
	CastBuilder(Expression operand)	Creates a CAST builder.

Uses of Expression in io.github.torand.fastersql.function.system

Subinterfaces of Expression in io.github.torand.fastersql.function.system

Modifier and Type	Interface	Description
interface	SystemFunction	Defines a function that returns a single value without operating on table rows.

Classes in io.github.torand.fastersql.function.system that implement Expression

Modifier and Type	Class	Description
class	CurrentDate	Implements the current date system function.
class	CurrentTime	Implements the current time system function.
class	CurrentTimestamp	Implements the current timestamp system function.

Uses of Expression in io.github.torand.fastersql.model

Classes in io.github.torand.fastersql.model that implement Expression

Modifier and Type	Class	Description
class	Column	Represents a column in a database table.

Uses of Expression in io.github.torand.fastersql.predicate

Methods in io.github.torand.fastersql.predicate with parameters of type Expression

Modifier and Type	Method	Description
default Predicate	LeftOperand.between(Expression lowerBound, Expression upperBound)	Creates a 'between' predicate from this left operand and the specified lower and upper bound expressions.
default Predicate	LeftOperand.eq(Expression expression)	Creates an equivalence predicate from this left operand and the specified expression.
default Predicate	LeftOperand.ge(Expression expression)	Creates a 'greater than or equal' predicate from this left operand and the specified expression.
default Predicate	LeftOperand.gt(Expression expression)	Creates a 'greater than' predicate from this left operand and the specified expression.
default Predicate	LeftOperand.le(Expression expression)	Creates a 'less than or equal' predicate from this left operand and the specified expression.
default Predicate	LeftOperand.lt(Expression expression)	Creates a 'less than' predicate from this left operand and the specified expression.
default Predicate	LeftOperand.ne(Expression expression)	Creates a non-equivalence predicate from this left operand and the specified expression.
default Predicate	LeftOperand.notBetween(Expression lowerBound, Expression upperBound)	Creates a 'not between' predicate from this left operand and the specified lower and upper bound expressions.

Uses of Expression in io.github.torand.fastersql.predicate.comparison

Methods in io.github.torand.fastersql.predicate.comparison with parameters of type Expression

Modifier and Type	Method	Description
static Between	ComparisonPredicates.between(LeftOperand left, Expression lowerBound, Expression upperBound)	Creates a between predicate taking expressions as lower and upper bound operands.
static Eq	ComparisonPredicates.eq(LeftOperand left, Expression right)	Creates an equivalence predicate taking an expression as right operand.
static Ge	ComparisonPredicates.ge(LeftOperand left, Expression right)	Creates a greater than or equal predicate taking an expression as right operand.
static Gt	ComparisonPredicates.gt(LeftOperand left, Expression right)	Creates a greater than predicate taking an expression as right operand.
static Le	ComparisonPredicates.le(LeftOperand left, Expression right)	Creates a less than or equal predicate taking an expression as right operand.
static Lt	ComparisonPredicates.lt(LeftOperand left, Expression right)	Creates a less than predicate taking an expression as right operand.
static Ne	ComparisonPredicates.ne(LeftOperand left, Expression right)	Creates a non-equivalence predicate taking an expression as right operand.

Uses of Expression in io.github.torand.fastersql.statement

Methods in io.github.torand.fastersql.statement with parameters of type Expression

Modifier and Type	Method	Description
UpdateStatement	UpdateStatement.set(Column column, Expression value)	Adds an expression value to be updated for a column.
InsertStatement	InsertStatement.value(Column column, Expression value)	Adds an expression value to be inserted into a column.

Uses of Expression in io.github.torand.fastersql.subquery

Classes in io.github.torand.fastersql.subquery that implement Expression

Modifier and Type	Class	Description
class	ExpressionSubquery	Implements a subquery to be used as projection or as operand for a predicate.