public non-sealed Interface Field<T>

Column expressions or fields can be used in a variety of SQL statements and clauses, including (non-exhaustive list):

• SELECT clause, e.g. through DSL#select(SelectField) (every Field is a subtype of SelectField)
• WHERE clause, e.g. through SelectWhereStep#where(Field) (Field<Boolean> can behave like a Condition, regardless if your RDBMS supports the BOOLEAN type)
• GROUP BY clause, e.g. through SelectGroupByStep#groupBy(GroupField...) (every Field is a subtype of GroupField)
• HAVING clause, e.g. through SelectHavingStep#having(Field)
• ORDER BY clause, e.g. through SelectOrderByStep#orderBy(OrderField) (every Field is a subtype of OrderField)
• When creating a Condition, e.g. through Field#eq(Field)
• As a function argument, e.g. through DSL#abs(Field)
• Many more...

Example:

// Assuming import static org.jooq.impl.DSL.*;

using(configuration)
   .select(ACTOR.LAST_NAME)  // Field reference
   .from(ACTOR)
   .groupBy(ACTOR.LAST_NAME) // Field reference
   .orderBy(ACTOR.LAST_NAME) // Field reference
   .fetch();

Instances can be created using a variety of ways, including:

• DSL#field(String) and overloads for plain SQL field expression.
• DSL#field(Name) and overloads for field identifier references.
• DSL#field(Condition) for predicates as fields.
• DSL#field(Select) for correlated subqueries.
• TableField referenced from generated tables
• DSL#val(Object) and overloads to create bind variables explicitly
• DSL#inline(Object) and overloads to create inline values (constants, literals) explicitly