## 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.`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 dataMapName, String sql)` 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(Map<String,?> parameters)`
    `SQLSelect<T>` | SQLSelect.`params(String name, Object value)`
    `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.
    `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–2023 Apache Cayenne. All rights reserved.