Uses of Interface
org.springframework.data.relational.core.sql.Expression

Packages that use Expression

Package	Description
org.springframework.data.r2dbc.core	Core domain types around DatabaseClient.
org.springframework.data.r2dbc.query	Query and update support.
org.springframework.data.relational.core.sql	Statement Builder implementation.

Uses of Expression in org.springframework.data.r2dbc.core

Methods in org.springframework.data.r2dbc.core that return types with arguments of type Expression

Modifier and Type	Method	Description
List<Expression>	StatementMapper.SelectSpec.getSelectList()

Methods in org.springframework.data.r2dbc.core with parameters of type Expression

Modifier and Type	Method	Description
StatementMapper.SelectSpec	StatementMapper.SelectSpec.withProjection(Expression... expressions)	Associate expressions with the select list and create a new StatementMapper.SelectSpec.

Method parameters in org.springframework.data.r2dbc.core with type arguments of type Expression

Modifier and Type	Method	Description
StatementMapper.SelectSpec	StatementMapper.SelectSpec.withProjection(Collection<Expression> projectedFields)	Associate projectedFields with the select and create a new StatementMapper.SelectSpec.

Uses of Expression in org.springframework.data.r2dbc.query

Methods in org.springframework.data.r2dbc.query that return Expression

Modifier and Type	Method	Description
Expression	QueryMapper.getMappedObject(Expression expression, RelationalPersistentEntity<?> entity)	Map the Expression object to apply field name mapping using the type to read.

Methods in org.springframework.data.r2dbc.query with parameters of type Expression

Modifier and Type	Method	Description
Expression	QueryMapper.getMappedObject(Expression expression, RelationalPersistentEntity<?> entity)	Map the Expression object to apply field name mapping using the type to read.

Uses of Expression in org.springframework.data.relational.core.sql

Subinterfaces of Expression in org.springframework.data.relational.core.sql

Modifier and Type	Interface	Description
interface	Condition	AST Segment for a condition.

Classes in org.springframework.data.relational.core.sql that implement Expression

Modifier and Type	Class	Description
class	AliasedExpression	An expression with an alias.
class	AnalyticFunction	Represents an analytic function, also known as windowing function
class	AndCondition	Condition representing an AND relation between two Conditions.
class	AsteriskFromTable	Segment to select all columns from a Table.
class	Between	BETWEEN Condition comparing between Expressions.
class	BindMarker	Bind marker/parameter placeholder used to construct prepared statements with parameter substitution.
class	BooleanLiteral	Represents a Boolean literal.
class	Cast	Represents a CAST expression like CAST(something AS JSON.
class	Column	Column name within a SELECT … FROM clause.
class	Comparison	Comparing Condition comparing two Expressions.
class	ConstantCondition	Condition representing fixed sql predicate.
static class	Expressions.SimpleExpression
class	FalseCondition	Simple condition that evaluates to SQL FALSE.
class	In	IN Condition clause.
class	IsNull	IS NULL Condition.
class	Like	LIKE Condition comparing two Expressions.
class	Literal<T>	Represents a literal.
class	MultipleCondition	Wrapper for multiple Conditions.
class	NestedCondition	Condition group wrapping a nested Condition with parentheses.
class	Not
class	NumericLiteral	Represents a Number literal.
class	OrCondition	Condition representing an OR relation between two Conditions.
class	SimpleFunction	Simple function accepting one or more Expressions.
class	StringLiteral	Represents a CharSequence literal.
class	SubselectExpression	Wrapper for a Select query to be used as subselect.
class	TrueCondition	Simple condition that evaluates to SQL TRUE.

Methods in org.springframework.data.relational.core.sql that return Expression

Modifier and Type	Method	Description
static Expression	Expressions.asterisk()
static Expression	Expressions.asterisk(Table table)
static Expression	Expressions.cast(Expression expression, String targetType)
static Expression	Cast.create(Expression expression, String targetType)	Creates a new CAST expression.
Expression	Between.getBegin()
Expression	Between.getColumn()
Expression	Between.getEnd()
Expression	OrderByField.getExpression()
Expression	Comparison.getLeft()
Expression	Like.getLeft()
Expression	Comparison.getRight()
Expression	Like.getRight()
Expression	AssignValue.getValue()
static Expression	Expressions.just(String sql)	Creates a plain sql Expression.

Methods in org.springframework.data.relational.core.sql that return types with arguments of type Expression

Modifier and Type	Method	Description
List<Expression>	SimpleFunction.getExpressions()

Methods in org.springframework.data.relational.core.sql with parameters of type Expression

Modifier and Type	Method	Description
SelectBuilder.SelectOnConditionComparison	SelectBuilder.SelectOnCondition.and(Expression column)	Declare an additional source column in the JOIN.
Between	Column.between(Expression begin, Expression end)	Creates a BETWEEN Condition.
static Between	Conditions.between(Expression columnOrExpression, Expression begin, Expression end)	Creates a BETWEEN Condition.
static Expression	Expressions.cast(Expression expression, String targetType)
static SimpleFunction	Functions.coalesce(Expression... expressions)	Creates a new COALESCE function.
static SimpleFunction	Functions.count(Expression... columns)	Creates a new COUNT function.
static AnalyticFunction	AnalyticFunction.create(String function, Expression... arguments)
static AssignValue	AssignValue.create(Column target, Expression value)	Creates a value assignment to a Column given an Expression.
static Between	Between.create(Expression columnOrExpression, Expression begin, Expression end)	Creates a new Between Condition given two Expressions.
static Expression	Cast.create(Expression expression, String targetType)	Creates a new CAST expression.
static Comparison	Comparison.create(Expression leftColumnOrExpression, String comparator, Expression rightColumnOrExpression)	Creates a new Comparison Condition given two Expressions.
static In	In.create(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static In	In.create(Expression columnOrExpression, Expression arg)	Creates a new In Condition given left and right Expressions.
static In	In.create(Expression columnOrExpression, Expression... expressions)	Creates a new In Condition given left and right Expressions.
static IsNull	IsNull.create(Expression expression)	Creates a new IsNull expression.
static Like	Like.create(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a new Like Condition given two Expressions.
static In	In.createNotIn(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static In	In.createNotIn(Expression columnOrExpression, Expression arg)	Creates a new In Condition given left and right Expressions.
static In	In.createNotIn(Expression columnOrExpression, Expression... expressions)	Creates a new In Condition given left and right Expressions.
SelectBuilder.SelectFromAndJoinCondition	SelectBuilder.SelectOnConditionComparison.equals(Expression column)	Declare an equals Condition between the source column and the target Column.
static OrderByField	OrderByField.from(Expression expression)	Creates a new OrderByField from an Expression applying default ordering.
static OrderByField	OrderByField.from(Expression expression, Sort.Direction direction)	Creates a new OrderByField from an Expression applying a given ordering.
static SimpleFunction	Functions.greatest(Expression... expressions)	Creates a new GREATEST function.
In	Column.in(Expression... expression)	Creates a new In Condition given right Expressions.
static Condition	Conditions.in(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static In	Conditions.in(Expression columnOrExpression, Expression arg)	Creates a IN clause.
static In	Conditions.in(Expression columnOrExpression, Expression... expressions)	Creates a new In Condition given left and right Expressions.
static Comparison	Conditions.isEqual(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a = (equals) Condition.
Comparison	Column.isEqualTo(Expression expression)	Creates a = (equals) Condition.
Comparison	Column.isGreater(Expression expression)	Creates a != (not equals) Condition.
static Comparison	Conditions.isGreater(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a <= (greater ) Condition comparing left is greater than right.
Comparison	Column.isGreaterOrEqualTo(Expression expression)	Creates a <= (greater or equal to) Condition.
static Comparison	Conditions.isGreaterOrEqualTo(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a <= (greater or equal to) Condition comparing left is greater than or equal to right.
Comparison	Column.isLess(Expression expression)	Creates a < (less) Condition.
static Comparison	Conditions.isLess(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a < (less) Condition comparing left is less than right.
Comparison	Column.isLessOrEqualTo(Expression expression)	CCreates a <= (greater) Condition.
static Comparison	Conditions.isLessOrEqualTo(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a <= (less or equal to) Condition comparing left is less than or equal to right.
static Comparison	Conditions.isNotEqual(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a != (not equals) Condition.
Comparison	Column.isNotEqualTo(Expression expression)	Creates a != (not equals) Condition.
static IsNull	Conditions.isNull(Expression expression)	Creates a IS NULL condition.
static SimpleFunction	Functions.least(Expression... expressions)	Creates a new LEAST function.
Like	Column.like(Expression expression)	Creates a LIKE Condition.
static Like	Conditions.like(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a LIKE Condition.
static SimpleFunction	Functions.lower(Expression expression)	Creates a new LOWER function.
Between	Column.notBetween(Expression begin, Expression end)	Creates a NOT BETWEEN Condition.
static Between	Conditions.notBetween(Expression columnOrExpression, Expression begin, Expression end)	Creates a NOT BETWEEN Condition.
In	Column.notIn(Expression... expression)	Creates a new not In Condition given right Expressions.
static Condition	Conditions.notIn(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new NOT IN Condition given left and right Expressions.
static In	Conditions.notIn(Expression columnOrExpression, Expression arg)	Creates a NOT IN clause.
static In	Conditions.notIn(Expression columnOrExpression, Expression... expressions)	Creates a new NOT IN Condition given left and right Expressions.
Like	Column.notLike(Expression expression)	Creates a NOT LIKE Condition.
static Like	Conditions.notLike(Expression leftColumnOrExpression, Expression rightColumnOrExpression)	Creates a NOT LIKE Condition.
SelectBuilder.SelectOnConditionComparison	SelectBuilder.SelectOn.on(Expression column)	Declare the source column in the JOIN.
AnalyticFunction	AnalyticFunction.orderBy(Expression... orderByExpression)
SelectBuilder.SelectFromAndOrderBy	SelectBuilder.SelectFromAndOrderBy.orderBy(Expression... columns)
SelectBuilder.SelectOrdered	SelectBuilder.SelectOrdered.orderBy(Expression... columns)	Add one or more columns to order by.
AnalyticFunction	AnalyticFunction.partitionBy(Expression... partitionBy)
SelectBuilder.SelectAndFrom	SelectBuilder.select(Expression expression)	Include a Expression in the select list.
SelectBuilder.SelectAndFrom	SelectBuilder.select(Expression... expressions)	Include one or more Expressions in the select list.
SelectBuilder.SelectFrom	SelectBuilder.SelectAndFrom.select(Expression expression)	Include a Expression in the select list.
SelectBuilder.SelectFrom	SelectBuilder.SelectAndFrom.select(Expression... expressions)	Include one or more Expressions in the select list.
static SelectBuilder.SelectAndFrom	StatementBuilder.select(Expression expression)	Creates a new SelectBuilder and includes the SELECT columns.
static SelectBuilder.SelectAndFrom	StatementBuilder.select(Expression... expressions)	Creates a new SelectBuilder and includes one or more SELECT columns.
AssignValue	Column.set(Expression value)	Creates a value assignment.
static SimpleFunction	Functions.upper(Expression expression)	Creates a new UPPER function.
static AssignValue	Assignments.value(Column target, Expression value)	Creates a value assignment to a Column given an Expression.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertIntoColumnsAndValuesWithBuild.value(Expression value)	Add a value to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValues.value(Expression value)	Add a value to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValuesWithBuild.value(Expression value)	Add a value to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values(Expression... values)	Add one or more values to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValues.values(Expression... values)	Add one or more values to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValuesWithBuild.values(Expression... values)	Add one or more values to the VALUES list.

Method parameters in org.springframework.data.relational.core.sql with type arguments of type Expression

Modifier and Type	Method	Description
static SimpleFunction	Functions.count(Collection<? extends Expression> columns)	Creates a new COUNT function.
static In	In.create(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static SimpleFunction	SimpleFunction.create(String functionName, List<? extends Expression> expressions)	Creates a new SimpleFunction given functionName and List of Expressions.
static In	In.createNotIn(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static SimpleFunction	Functions.greatest(List<? extends Expression> expressions)	Creates a new GREATEST function.
static Condition	Conditions.in(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new In Condition given left and right Expressions.
static Condition	Conditions.notIn(Expression columnOrExpression, Collection<? extends Expression> expressions)	Creates a new NOT IN Condition given left and right Expressions.
SelectBuilder.SelectAndFrom	SelectBuilder.select(Collection<? extends Expression> expressions)	Include one or more Expressions in the select list.
SelectBuilder.SelectFrom	SelectBuilder.SelectAndFrom.select(Collection<? extends Expression> expressions)	Include one or more Expressions in the select list.
static SelectBuilder.SelectAndFrom	StatementBuilder.select(Collection<? extends Expression> expressions)	Creates a new SelectBuilder and includes one or more Expressions in the select list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values(Collection<? extends Expression> values)	Add one or more values to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValues.values(Collection<? extends Expression> values)	Add one or more values to the VALUES list.
InsertBuilder.InsertValuesWithBuild	InsertBuilder.InsertValuesWithBuild.values(Collection<? extends Expression> values)	Add one or more values to the VALUES list.

Constructors in org.springframework.data.relational.core.sql with parameters of type Expression

Modifier	Constructor	Description
	AliasedExpression(Expression expression, String alias)
	AliasedExpression(Expression expression, SqlIdentifier alias)