Package io.github.torand.fastersql.alias

Class ColumnRef

java.lang.Object

io.github.torand.fastersql.alias.ColumnRef

All Implemented Interfaces:

Expression, OrderExpression, LeftOperand, Projection, Sql

public class ColumnRef
extends Object
implements LeftOperand, OrderExpression, Expression

References a column using a combination of a table alias and a column alias. Typically used to refer to columns in a subquery (inline view).

Method Summary

Modifier and Type	Method	Description
Optional<ColumnAlias>	alias()	Gets the column alias (label) assigned for this projection.
Stream<ColumnAlias>	aliasRefs()	Gets the column aliases referenced by this fragment.
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.
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.predicate.LeftOperand

between, between, eq, eq, eq, eq, ge, ge, ge, ge, gt, gt, gt, gt, in, in, in, in, isNotNull, isNull, le, le, le, le, like, like, lt, lt, lt, lt, ne, ne, ne, ne, notBetween, notBetween, notIn, notIn, notIn, notLike

Methods inherited from interface io.github.torand.fastersql.order.OrderExpression

asc, ascIf, desc

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

columnRefs

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.

aliasRefs

public Stream<ColumnAlias> aliasRefs()

Description copied from interface: Sql

Gets the column aliases referenced by this fragment. For validation purposes.

Specified by:

aliasRefs in interface Sql

Returns:

the column aliases referenced by this fragment.

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.