Package org.tentackle.dbms.dsl
package org.tentackle.dbms.dsl
A type-safe DSL for SQL projection queries.
Projection queries deliver plain data, not PDOs. They are executed on the low level
of the database layer, i.e. without a security manager, and their results are mapped
to DTOs by ResultSetWrapper.toList(java.lang.Class).
The DSL builds the SQL-code and the parameter set of a Query
from typed expressions instead of hand-written SQL-strings. It knows about the
DataTypes and thus about the columns a value is mapped to,
and it lets the Backend generate everything that is dialect-specific.
- See Also:
-
ClassDescriptionAn expression with a column alias.An expression tested to be within a range of values.BindValue<T>A value bound to the prepared statement.Conditions combined by a logical
ANDorOR.Two expressions compared by anOperator.A boolean SQL expression.The entry point of the query DSL.A sub-select tested to return at least one row.Expression<T>A typed SQL expression.Field<T>A column of a table.An expression tested to be one of a set of values or sub-select rows.A joined table.The pending join of aSelect.
Enforces the join condition to be provided before the select can be continued.The logical operator combining conditions.A negated condition.An expression tested to be (not) null.A comparison operator.A condition given as plain SQL-code.An expression given as plain SQL-code.Collects the SQL-code and the parameters while anSqlElementis rendered.ASELECT-statement.An expression of theORDER BY-clause.The sort order of anORDER BY-expression.An element of an SQL query.SqlFunction<T>An SQL function or aggregate.SubSelect<T>A sub-select used as a scalar expression.A table or a derived table (i.e. a sub-select in theFROM-clause).