## 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 and Description
    --- | ---
    `SQLSelect<T>` | SQLSelect.`addPrefetch(PrefetchTreeNode node)` Merges a prefetch into the query prefetch tree.
    `SQLSelect<T>` | SQLSelect.`addPrefetch(String path, int semantics)` Merges a prefetch path with specified semantics 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)`
    `SQLSelect<T>` | SQLSelect.`offset(int fetchOffset)`
    `SQLSelect<T>` | SQLSelect.`pageSize(int pageSize)`
    `SQLSelect<T>` | SQLSelect.`param(String name, Object value)`
    `SQLSelect<T>` | SQLSelect.`params(Map<String,?> parameters)`
    `SQLSelect<T>` | SQLSelect.`params(String name, Object value)` Deprecated. since 4.2 Use `param(String, Object)`
    `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. Use `#scalarQuery(String, Class)` method.
    `static <T> SQLSelect<T>` | SQLSelect.`scalarQuery(Class<T> type, String dataMapName, String sql)` Deprecated. since 4.2. Use `#scalarQuery(String, String, Class)` method.
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery(String sql)` Deprecated. since 4.2. Use `columnQuery(String)`
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery(String sql, Class<?>... types)` Deprecated. since 4.2. Use `columnQuery(String, Class...)`
    `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. Use `columnQuery(String, String)`
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery(String sql, String dataMapName, Class<?>... types)` Deprecated. since 4.2. Use `columnQuery(String, String, Class...)`
    `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`

Copyright © 2001–2021 Apache Cayenne. All rights reserved.