# Uses of Class
org.apache.cayenne.query.SQLSelect

Packages that use SQLSelect
Package
Description
org.apache.cayenne.query
Defines standard queries supported by Cayenne and extension mechanism to create custom queries.

- ## Uses of SQLSelect in org.apache.cayenne.query

  Methods in org.apache.cayenne.query that return SQLSelect
  Modifier and Type
  Method
  Description
  `SQLSelect<T>`
  SQLSelect.`addPrefetch(String path, int semantics)`
  Merges a prefetch path with specified semantics into the query prefetch tree.
  `SQLSelect<T>`
  SQLSelect.`addPrefetch(PrefetchTreeNode node)`
  Merges a prefetch into the query prefetch tree.
  `SQLSelect<T>`
  SQLSelect.`append(String sqlChunk)`
  Appends a piece of SQL to the previously stored SQL template.
  `SQLSelect<T>`
  SQLSelect.`cacheGroup(String cacheGroup)`
  `SQLSelect<T>`
  SQLSelect.`cacheStrategy(QueryCacheStrategy strategy)`
  `SQLSelect<T>`
  SQLSelect.`cacheStrategy(QueryCacheStrategy strategy, String cacheGroup)`
  `SQLSelect<T>`
  SQLSelect.`columnNameCaps(CapsStrategy columnNameCaps)`
  Sets a column name capitalization policy applied to selecting queries.
  `static SQLSelect<Object[]>`
  SQLSelect.`columnQuery(String sql)`
  Creates query that selects scalar values (as Object[]) and uses default routing
  `static SQLSelect<Object[]>`
  SQLSelect.`columnQuery(String sql, Class<?>... types)`
  Creates query that selects scalar values (as Object[]) and uses default routing
  `static SQLSelect<Object[]>`
  SQLSelect.`columnQuery(String sql, String dataMapName)`
  Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
  `static SQLSelect<Object[]>`
  SQLSelect.`columnQuery(String sql, String dataMapName, Class<?>... types)`
  Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
  `static SQLSelect<DataRow>`
  SQLSelect.`dataRowQuery(String sql)`
  Creates a query that selects DataRows and uses default routing.
  `static SQLSelect<DataRow>`
  SQLSelect.`dataRowQuery(String sql, Class<?>... types)`
  Creates a query that selects DataRows and uses default routing.
  `static SQLSelect<DataRow>`
  SQLSelect.`dataRowQuery(String dataMapName, String sql)`
  Creates a query that selects DataRows and uses routing based on the provided DataMap name.
  `static SQLSelect<DataRow>`
  SQLSelect.`dataRowQuery(String dataMapName, String sql, Class<?>... types)`
  Creates a query that selects DataRows and uses routing based on the provided DataMap name.
  `SQLSelect<T>`
  SQLSelect.`limit(int fetchLimit)`
  `SQLSelect<T>`
  SQLSelect.`localCache()`
  Instructs Cayenne to look for query results in the "local" cache when running the query.
  `SQLSelect<T>`
  SQLSelect.`localCache(String cacheGroup)`
  Instructs Cayenne to look for query results in the "local" cache when running the query.
  `SQLSelect<T>`
  SQLSelect.`lowerColumnNames()`
  Equivalent of setting `CapsStrategy.LOWER`
  `<E> SQLSelect<E>`
  SQLSelect.`map(Function<T,E> mapper)`
  Map result of this query by processing with a given function.
  `SQLSelect<T>`
  SQLSelect.`offset(int fetchOffset)`
  `SQLSelect<T>`
  SQLSelect.`pageSize(int pageSize)`
  `SQLSelect<T>`
  SQLSelect.`param(String name, Object value)`
  `SQLSelect<T>`
  SQLSelect.`params(String name, Object value)`
  Deprecated.
  since 4.2 Use `param(String, Object)`
  `SQLSelect<T>`
  SQLSelect.`params(Map<String,?> parameters)`
  `SQLSelect<T>`
  SQLSelect.`paramsArray(Object... params)`
  Initializes positional parameters of the query.
  `SQLSelect<T>`
  SQLSelect.`paramsList(List<Object> params)`
  Initializes positional parameters of the query.
  `static <T> SQLSelect<T>`
  SQLSelect.`query(Class<T> type, String sql)`
  Creates a query that selects DataObjects.
  `SQLSelect<T>`
  SQLSelect.`queryTimeout(int queryTimeout)`
  Sets query timeout
  `static <T> SQLSelect<T>`
  SQLSelect.`scalarQuery(Class<T> type, String sql)`
  Deprecated.
  since 4.2.
  `static <T> SQLSelect<T>`
  SQLSelect.`scalarQuery(Class<T> type, String dataMapName, String sql)`
  Deprecated.
  since 4.2.
  `static SQLSelect<Object[]>`
  SQLSelect.`scalarQuery(String sql)`
  Deprecated.
  since 4.2.
  `static SQLSelect<Object[]>`
  SQLSelect.`scalarQuery(String sql, Class<?>... types)`
  Deprecated.
  since 4.2.
  `static <T> SQLSelect<T>`
  SQLSelect.`scalarQuery(String sql, Class<T> type)`
  Creates query that selects scalar value and uses default routing
  `static SQLSelect<Object[]>`
  SQLSelect.`scalarQuery(String sql, String dataMapName)`
  Deprecated.
  since 4.2.
  `static SQLSelect<Object[]>`
  SQLSelect.`scalarQuery(String sql, String dataMapName, Class<?>... types)`
  Deprecated.
  since 4.2.
  `static <T> SQLSelect<T>`
  SQLSelect.`scalarQuery(String sql, String dataMapName, Class<T> type)`
  Creates query that selects scalar value and uses default routing
  `SQLSelect<T>`
  SQLSelect.`sharedCache()`
  Instructs Cayenne to look for query results in the "shared" cache when running the query.
  `SQLSelect<T>`
  SQLSelect.`sharedCache(String cacheGroup)`
  Instructs Cayenne to look for query results in the "shared" cache when running the query.
  `SQLSelect<T>`
  SQLSelect.`statementFetchSize(int size)`
  Sets JDBC statement's fetch size (0 for no default size)
  `SQLSelect<T>`
  SQLSelect.`upperColumnNames()`
  Equivalent of setting `CapsStrategy.UPPER`