Uses of Interface
io.github.torand.fastersql.sql.Sql

Packages that use Sql

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.join	Provides classes representing join clauses.
io.github.torand.fastersql.model	Provides classes representing the database model.
io.github.torand.fastersql.order	Provides classes and interfaces representing order clauses.
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.predicate.compound	Provides classes and interfaces representing predicates made up by multiple sub-predicates.
io.github.torand.fastersql.projection	Provides classes and interfaces related to projections.
io.github.torand.fastersql.relation	Provides classes and interfaces representing relations.
io.github.torand.fastersql.setoperation	Provides classes representing set operations.
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 Sql in io.github.torand.fastersql.alias

Subinterfaces of Sql in io.github.torand.fastersql.alias

Modifier and Type	Interface	Description
interface	Alias	Defines an alias (label) for a column or table

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

Modifier and Type	Class	Description
class	ColumnAlias	Represents an alias (label) for a projection
class	ColumnRef	References a column using a combination of a table alias and a column alias.
class	TableAlias	Represents an alias (label) for a table

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

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

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 Sql in io.github.torand.fastersql.expression

Subinterfaces of Sql 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 Sql in io.github.torand.fastersql.expression.arithmetic

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

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.

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

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

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

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

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

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

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.

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

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

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.

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

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

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

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

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

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 Sql in io.github.torand.fastersql.join

Classes in io.github.torand.fastersql.join that implement Sql

Modifier and Type	Class	Description
class	Join	Implements a JOIN clause.

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

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

Modifier and Type	Class	Description
class	Column	Represents a column in a database table.
class	Table	Represents a database table.
class	TableModel<T extends TableModel<?>>	Models a database table.

Uses of Sql in io.github.torand.fastersql.order

Subinterfaces of Sql in io.github.torand.fastersql.order

Modifier and Type	Interface	Description
interface	Order	Defines an ordering specification for the ORDER BY clause.
interface	OrderExpression	Defines an expression specifying the ordering of rows from a query.

Classes in io.github.torand.fastersql.order that implement Sql

Modifier and Type	Class	Description
class	Ascending	Implements an ascending order clause.
class	Descending	Implements a descending order clause.

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

Subinterfaces of Sql in io.github.torand.fastersql.predicate

Modifier and Type	Interface	Description
interface	LeftOperand	Defines the left operand of an expression.
interface	Predicate	Defines a restriction on the rows fetched by a SELECT or affected by an UPDATE or DELETE.

Classes in io.github.torand.fastersql.predicate that implement Sql

Modifier and Type	Class	Description
class	ExistsSubquery	Implements the 'existence' (at least one row) predicate.
class	In	Implements the 'member of set' predicate, using a set of scalar values.
class	InSubquery	Implements the 'member of set' predicate, using a set defined by a subquery.
class	IsNull	Implements the 'is null' predicate.
class	Like	Implements the pattern matching predicate.

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

Classes in io.github.torand.fastersql.predicate.comparison that implement Sql

Modifier and Type	Class	Description
class	Between	Implements the between predicate.
class	Eq	Implements the equivalence predicate.
class	Ge	Implements the greater than or equal predicate.
class	Gt	Implements the greater than predicate.
class	Le	Implements the less than or equal predicate.
class	Lt	Implements the less than predicate.
class	Ne	Implements the non-equivalence predicate.

Uses of Sql in io.github.torand.fastersql.predicate.compound

Classes in io.github.torand.fastersql.predicate.compound that implement Sql

Modifier and Type	Class	Description
class	And	Implements the compound predicate using the boolean operator AND on its operands.
class	Not	Implements the compound predicate using the boolean negation operator on its operand.
class	Or	Implements the compound predicate using the boolean operator OR on its operands.

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

Subinterfaces of Sql in io.github.torand.fastersql.projection

Modifier and Type	Interface	Description
interface	Projection	Defines a construct which can be returned in a result set, i.e. an item in the SELECT clause.

Classes in io.github.torand.fastersql.projection that implement Sql

Modifier and Type	Class	Description
class	ColumnPosition	Represents an enumeration of a projection, that is, a 1-based number referencing a single projection element in a SELECT clause.

Uses of Sql in io.github.torand.fastersql.relation

Subinterfaces of Sql in io.github.torand.fastersql.relation

Modifier and Type	Interface	Description
interface	Relation	Defines a table of columns and rows, whether a permanent database table or a temporary table (the result of a subquery).

Uses of Sql in io.github.torand.fastersql.setoperation

Classes in io.github.torand.fastersql.setoperation that implement Sql

Modifier and Type	Class	Description
class	SetOperation	Implements a set operation.

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

Subinterfaces of Sql in io.github.torand.fastersql.statement

Modifier and Type	Interface	Description
interface	PreparableStatement	Defines a statement that can be formatted as SQL.

Classes in io.github.torand.fastersql.statement that implement Sql

Modifier and Type	Class	Description
class	DeleteStatement	Implements a DELETE statement.
class	InsertBatchStatement<T>	Implements an INSERT statement for batch (multi-row) insertion.
class	InsertStatement	Implements an INSERT statement for single row insertion.
class	SelectSetOpStatement	Implements a SELECT statement with set operations.
class	SelectStatement	Implements a SELECT statement.
class	TruncateStatement	Implements a TRUNCATE statement.
class	UpdateStatement	Implements an UPDATE statement.

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

Subinterfaces of Sql in io.github.torand.fastersql.subquery

Modifier and Type	Interface	Description
interface	Subquery	Defines a subquery.

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

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