# Uses of Class
org.apache.torque.sql.Query

Packages that use Query
Package
Description
org.apache.torque.adapter
Adapters between Torque and various databases.
org.apache.torque.sql
This package contains classes which are mainly used in the SQL generation process.
org.apache.torque.sql.objectbuilder
This package contains classes which can build PreparedStatementParts from a single value or column.
org.apache.torque.sql.whereclausebuilder
This package contains classes which can build PreparedStatementParts from a WhereClauseExpression.

- ## Uses of Query in org.apache.torque.adapter

  Methods in org.apache.torque.adapter with parameters of type Query
  Modifier and Type
  Method
  Description
  `void`
  AbstractAdapter.`generateLimits(Query query, long offset, int limit)`
  This method is used to generate the database specific query extension to limit the number of record returned.
  `void`
  Adapter.`generateLimits(Query query, long offset, int limit)`
  This method is used to generate the database specific query extension to limit the number of record returned.
  `void`
  DerbyAdapter.`generateLimits(Query query, long offset, int limit)`
  Build Derby-style query with limit or offset.
  `void`
  HsqldbAdapter.`generateLimits(Query query, long offset, int limit)`
  Generate a LIMIT limit OFFSET offset clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0.
  `void`
  MssqlAdapter.`generateLimits(Query query, long offset, int limit)`
  Modify a query to add limit and offset values for MSSQL.
  `void`
  MysqlAdapter.`generateLimits(Query query, long offset, int limit)`
  Generate a LIMIT offset, limit clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0.
  `void`
  OracleAdapter.`generateLimits(Query query, long offset, int limit)`
  Build Oracle-style query with limit or offset.
  `void`
  PostgresAdapter.`generateLimits(Query query, long offset, int limit)`
  Generate a LIMIT limit OFFSET offset clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0.

- ## Uses of Query in org.apache.torque.sql

  Methods in org.apache.torque.sql that return Query
  Modifier and Type
  Method
  Description
  `static Query`
  SqlBuilder.`buildQuery(Criteria crit)`
  Builds a Query from a criteria.
  Methods in org.apache.torque.sql that return types with arguments of type Query
  Modifier and Type
  Method
  Description
  `List<Query>`
  Query.`getParts()`
  Returns the parts of this query.
  Methods in org.apache.torque.sql with parameters of type Query
  Modifier and Type
  Method
  Description
  `static void`
  JoinBuilder.`processJoins(Criteria criteria, Query query)`
  Adds the Joins from the criteria to the query.

- ## Uses of Query in org.apache.torque.sql.objectbuilder

  Methods in org.apache.torque.sql.objectbuilder with parameters of type Query
  Modifier and Type
  Method
  Description
  `PreparedStatementPart`
  ObjectOrColumnPsPartBuilder.`buildPs(Object toBuildFrom, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a column or single value.
  `PreparedStatementPart`
  ObjectPsPartBuilder.`buildPs(Object toBuildFrom, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a single Object.
  Constructors in org.apache.torque.sql.objectbuilder with parameters of type Query
  Modifier
  Constructor
  Description
  ``
  `PreparedStatementPartForSubselect(Criteria toBuildFrom, Query outerQuery)`
  Constructor.

- ## Uses of Query in org.apache.torque.sql.whereclausebuilder

  Methods in org.apache.torque.sql.whereclausebuilder with parameters of type Query
  Modifier and Type
  Method
  Description
  `PreparedStatementPart`
  CurrentDateTimePsPartBuilder.`buildPs(WhereClauseExpression whereClauseExpression, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a WhereClauseExpression.
  `PreparedStatementPart`
  EnumValueBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Takes a WhereClauseExpression containing a enum object and unwraps the enum value.
  `PreparedStatementPart`
  InBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Takes a columnName and criteria and builds a SQL 'IN' expression taking into account the ignoreCase flag.
  `PreparedStatementPart`
  LikeBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Builds the PS part for a WhereClauseExpression with a LIKE operator.
  `PreparedStatementPart`
  NullValueBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a WhereClauseExpression which rhs is null and which has one of the comparison opertator =, <>, or !
  `PreparedStatementPart`
  StandardBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a WhereClauseExpression which RHS and LHS is a simple value.
  `PreparedStatementPart`
  VerbatimSqlConditionBuilder.`buildPs(WhereClauseExpression whereClausePart, boolean ignoreCase, Query query, Adapter adapter)`
  Builds the PS part for a WhereClauseExpression with a verbatim SQL condition.
  `PreparedStatementPart`
  WhereClausePsPartBuilder.`buildPs(WhereClauseExpression whereClauseExpression, boolean ignoreCase, Query query, Adapter adapter)`
  Builds a PreparedStatementPart from a WhereClauseExpression.