## 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<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`
    `SQLSelect<T>` | SQLSelect.`offset​(int fetchOffset)` |
    `SQLSelect<T>` | SQLSelect.`pageSize​(int pageSize)` |
    `SQLSelect<T>` | SQLSelect.`params​(String name, Object value)` |
    `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.
    `static <T> SQLSelect<T>` | SQLSelect.`scalarQuery​(Class<T> type, String sql)` | Creates a query that selects scalar values and uses default routing.
    `static <T> SQLSelect<T>` | SQLSelect.`scalarQuery​(Class<T> type, String dataMapName, String sql)` | Creates a query that selects scalar values and uses routing based on the provided DataMap name.
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery​(String sql)` | Creates query that selects scalar value and uses default routing
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery​(String sql, Class<?> firstType, Class<?>... types)` | Creates query that selects scalar values (as Object[]) and uses default routing
    `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)` | Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
    `static SQLSelect<Object[]>` | SQLSelect.`scalarQuery​(String sql, String dataMapName, Class<?> firstType, Class<?>... types)` | Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
    `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`