Uses of Interface
io.github.torand.fastersql.projection.Projection

Packages that use Projection

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.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.system	Provides classes and interfaces related to system functions.
io.github.torand.fastersql.model	Provides classes representing the database model.
io.github.torand.fastersql.projection	Provides classes and interfaces related to projections.
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 Projection in io.github.torand.fastersql.alias

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

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

Methods in io.github.torand.fastersql.alias that return Projection

Modifier and Type	Method	Description
Projection	ColumnRef.as(String alias)

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

Subinterfaces of Projection 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 Projection

Modifier and Type	Class	Description
class	GenericConstant<T>	Represents a scalar value constant of any type.
class	NullConstant	Represents the 'null' constant value.

Methods in io.github.torand.fastersql.constant that return Projection

Modifier and Type	Method	Description
Projection	GenericConstant.as(String alias)
Projection	NullConstant.as(String alias)
Projection	Constant.forColumn(Column column)	Creates a projection of the constant.
Projection	GenericConstant.forColumn(Column column)
Projection	NullConstant.forColumn(Column column)

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

Subinterfaces of Projection in io.github.torand.fastersql.expression

Modifier and Type	Interface	Description
interface	Expression	Defines an expression resulting in a scalar value or a table with rows and columns.

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

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

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	Subtraction	Implements the subtraction (difference) expression.

Methods in io.github.torand.fastersql.expression.arithmetic that return Projection

Modifier and Type	Method	Description
Projection	Addition.as(String alias)
Projection	Division.as(String alias)
Projection	Modulo.as(String alias)
Projection	Multiplication.as(String alias)
Projection	Subtraction.as(String alias)

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

Subinterfaces of Projection 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 Projection in io.github.torand.fastersql.function.aggregate

Subinterfaces of Projection 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 Projection

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 that return Projection

Modifier and Type	Method	Description
Projection	Avg.as(String alias)
Projection	Count.as(String alias)
Projection	CountAll.as(String alias)
Projection	Max.as(String alias)
Projection	Min.as(String alias)
Projection	Sum.as(String alias)

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

Subinterfaces of Projection 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 Projection

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	Floor	Implements the floor numeric function.
class	Length	Implements the length string function.
class	Lower	Implements the lower case string function.
class	Round	Implements the round 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 that return Projection

Modifier and Type	Method	Description
Projection	Abs.as(String alias)
Projection	Ceil.as(String alias)
Projection	Concat.as(String alias)
Projection	Floor.as(String alias)
Projection	Length.as(String alias)
Projection	Lower.as(String alias)
Projection	Round.as(String alias)
Projection	Substring.as(String alias)
Projection	ToChar.as(String alias)
Projection	ToNumber.as(String alias)
Projection	Upper.as(String alias)

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

Subinterfaces of Projection 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 Projection

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.

Methods in io.github.torand.fastersql.function.system that return Projection

Modifier and Type	Method	Description
Projection	CurrentDate.as(String alias)
Projection	CurrentTime.as(String alias)
Projection	CurrentTimestamp.as(String alias)

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

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

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

Methods in io.github.torand.fastersql.model that return Projection

Modifier and Type	Method	Description
Projection	Column.as(String alias)

Uses of Projection in io.github.torand.fastersql.projection

Methods in io.github.torand.fastersql.projection that return Projection

Modifier and Type	Method	Description
Projection	Projection.as(String alias)	Assigns a column alias (label) for this projection.

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

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

Modifier and Type	Method	Description
static SelectFromBuilder	Statements.select(Projection firstProjection, Projection... moreProjections)	Creates a SELECT statement builder.
static SelectFromBuilder	Statements.selectDistinct(Projection firstProjection, Projection... moreProjections)	Creates a SELECT statement builder with DISTINCT clause added.

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

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

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

Methods in io.github.torand.fastersql.subquery that return Projection

Modifier and Type	Method	Description
Projection	ExpressionSubquery.as(String alias)