Package io.github.torand.fastersql.subquery

Class ExpressionSubquery

java.lang.Object

io.github.torand.fastersql.subquery.ExpressionSubquery

All Implemented Interfaces:

Expression, Projection, Sql, Subquery

public class ExpressionSubquery
extends Object
implements Subquery, Expression

Implements a subquery to be used as projection or as operand for a predicate.

Constructor Summary

Constructors

Constructor	Description
ExpressionSubquery(SelectStatement query)	Creates an expression subquery.

Method Summary

Modifier and Type	Method	Description
Optional<ColumnAlias>	alias()	Gets the column alias (label) assigned for this projection.
Projection	as(String alias)	Assigns a column alias (label) for this projection.
Stream<Object>	params(Context context)	Gets the statement parameters introduced by this fragment.
SelectStatement	query()	Gets the SELECT statement of this subquery.
String	sql(Context context)	Formats object as an SQL fragment.

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.torand.fastersql.expression.Expression

dividedBy, dividedBy, minus, minus, mod, mod, plus, plus, times, times

Methods inherited from interface io.github.torand.fastersql.sql.Sql

aliasRefs, columnRefs

Constructor Details

ExpressionSubquery

public ExpressionSubquery(SelectStatement query)

Creates an expression subquery.

Parameters:

query - the query.

Method Details

sql

public String sql(Context context)

Description copied from interface: Sql

Formats object as an SQL fragment.

Specified by:

sql in interface Sql

Parameters:

context - the context (incl. dialect).

Returns:

the formatted SQL fragment.

params

public Stream<Object> params(Context context)

Description copied from interface: Sql

Gets the statement parameters introduced by this fragment.

Specified by:

params in interface Sql

Parameters:

context - the context (incl. dialect).

Returns:

the statement parameters.

query

public SelectStatement query()

Description copied from interface: Subquery

Gets the SELECT statement of this subquery.

Specified by:

query in interface Subquery

Returns:

the SELECT statement of this subquery.

as

public Projection as(String alias)

Description copied from interface: Projection

Assigns a column alias (label) for this projection.

Specified by:

as in interface Projection

Parameters:

alias - the column alias or label.

Returns:

the projection with specified alias assigned.

alias

public Optional<ColumnAlias> alias()

Description copied from interface: Projection

Gets the column alias (label) assigned for this projection.

Specified by:

alias in interface Projection

Returns:

the column alias (label) assigned for this projection.