# SOQL Lib

> Apex SOQL provides functional constructs for SOQL.

This file contains links to documentation sections following the llmstxt.org standard.

## Table of Contents

- [Getting Started](https://soql.beyondthecloud.dev/docs/getting-started.md): ![Deploy to Scratch Org and run tests](https://github.com/beyond-the-cloud-dev/soql-lib/actions/workflows/ci.yml/badge.svg)
- [Installation](https://soql.beyondthecloud.dev/installation.md): <!--
- [Overview](https://soql.beyondthecloud.dev/docs/overview.md): SOQL Lib is a modern Apex library designed as an intuitive alternative to the popular [FFLib Selectors](https://github.com/apex-enterprise-patterns...
- [Design](https://soql.beyondthecloud.dev/soql/advanced/design.md): SOQL Lib is a single-class solution.
- [Field-Level Security](https://soql.beyondthecloud.dev/soql/advanced/fls.md): [Enforce User Mode for Database Operations](https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_classes_enforce_usermode....
- [Known Issues](https://soql.beyondthecloud.dev/soql/advanced/knownIssues.md): Error: `System.QueryException: Variable does not exist: v1`
- [Mocking](https://soql.beyondthecloud.dev/soql/advanced/mocking.md): Mocking provides a way to substitute records from a database with some prepared data. Data can be prepared in the form of SObject records and lists...
- [Sharing Rules](https://soql.beyondthecloud.dev/soql/advanced/sharing.md): [Enforce User Mode for Database Operations](https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_classes_enforce_usermode....
- [DataCategoryFilter](https://soql.beyondthecloud.dev/soql/api/soql-data-category-filter.md): Specify and adjust single condition.
- [Distance](https://soql.beyondthecloud.dev/soql/api/soql-distance.md): Perform location based calculations.
- [Filter](https://soql.beyondthecloud.dev/soql/api/soql-filter.md): Specify and adjust single condition.
- [FilterGroup](https://soql.beyondthecloud.dev/soql/api/soql-filters-group.md): Create group of conditions.
- [HavingFilterGroup](https://soql.beyondthecloud.dev/soql/api/soql-having-filter-group.md): Create group of having conditions.
- [HavingFilter](https://soql.beyondthecloud.dev/soql/api/soql-having-filter.md): Specify and adjust single having condition.
- [JoinQuery](https://soql.beyondthecloud.dev/soql/api/soql-join.md): Construct join-query and use it in condition.
- [Logger](https://soql.beyondthecloud.dev/soql/api/soql-logger.md): Log failed queries with your own logging solution.
- [SubQuery](https://soql.beyondthecloud.dev/soql/api/soql-sub.md): Construct sub-query with provided API.
- [TypeOf](https://soql.beyondthecloud.dev/soql/api/soql-typeof.md): Construct `TYPEOF` expression with provided API.
- [SOQL](https://soql.beyondthecloud.dev/soql/api/soql.md): Apex Classes: `SOQL.cls` and `SOQL_Test.cls`.
- [Basic Features](https://soql.beyondthecloud.dev/soql/basic-features.md): The `SOQL.cls` class provides methods for building SOQL clauses dynamically.
- [Building Your Selector](https://soql.beyondthecloud.dev/soql/build-selector.md): :::info[New Selector Approach!]
- [AGGREGATE FUNCTIONS](https://soql.beyondthecloud.dev/soql/examples/aggregate-functions.md): For more details check [SOQL API - AGGREGATE FUNCTIONS](../api/soql.md#aggregate-functions).
- [DEBUGGING](https://soql.beyondthecloud.dev/soql/examples/debug.md): For more details check Check [SOQL API - DEBUGGING](../api/soql.md#debugging).
- [DISTANCE](https://soql.beyondthecloud.dev/soql/examples/distance.md): For more details check [SOQL API - DISTANCE](../api/soql-distance.md).
- [FIELD-LEVEL SECURITY](https://soql.beyondthecloud.dev/soql/examples/fls.md): For more details check [SOQL API - FIELD-LEVEL SECURITY](../api/soql.md#field-level-security) and [Advanced - FIELD-LEVEL SECURITY](../advanced/fls...
- [GROUP BY](https://soql.beyondthecloud.dev/soql/examples/group-by.md): For more details check Check [SOQL API - GROUP BY](../api/soql.md#group-by).
- [LIMIT](https://soql.beyondthecloud.dev/soql/examples/limit.md): For more details check Check [SOQL API - LIMIT](../api/soql.md#limit).
- [MOCKING](https://soql.beyondthecloud.dev/soql/examples/mocking.md): Mock SOQL results in Unit Tests.
- [OFFSET](https://soql.beyondthecloud.dev/soql/examples/offset.md): For more details check Check [SOQL API - OFFSET](../api/soql.md#offset).
- [ORDER BY](https://soql.beyondthecloud.dev/soql/examples/order-by.md): For more details check Check [SOQL API - ORDER BY](../api/soql.md#order-by).
- [RESULT](https://soql.beyondthecloud.dev/soql/examples/result.md): > **NOTE! 🚨**
- [USING SCOPE](https://soql.beyondthecloud.dev/soql/examples/scope.md): For more details check Check [SOQL API - USING SCOPE](../api/soql.md#using-scope).
- [SELECT](https://soql.beyondthecloud.dev/soql/examples/select.md): Specify fields that will be retrieved via query. Check [SOQL API - SELECT](../api/soql.md#select).
- [SHARING MODE](https://soql.beyondthecloud.dev/soql/examples/sharing-settings.md): For more details check Check [SOQL API - SHARING MODE](../api/soql.md#sharing-mode) and [Advanced - SHARING MODE](../advanced/sharing.md)
- [SUBQUERY](https://soql.beyondthecloud.dev/soql/examples/subquery.md): For more details check Check [SOQL API - SubQuery](../api/soql-sub.md).
- [TYPEOF](https://soql.beyondthecloud.dev/soql/examples/typeof.md): For more details check [SOQL API - TypeOf](../api/soql-typeof.md).
- [WHERE](https://soql.beyondthecloud.dev/soql/examples/where.md): Use [SOQL.FilterGroup](../api/soql-filters-group.md) and Use [SOQL.Filter](../api/soql-filter.md) to build your `WHERE` clause.
- [WITH DATA_CATEGORY](https://soql.beyondthecloud.dev/soql/examples/with-data-category.md): Use [SOQL.DataCategoryFilter](../api/soql-data-category-filter.md) to build your `WITH DATA_CATEGORY` clause.
- [Getting Started](https://soql.beyondthecloud.dev/soql/getting-started.md): The main module of the SOQL Lib consists of two concepts: **SOQL Builder** and **SOQL Selectors**.
- [Caching](https://soql.beyondthecloud.dev/cache/advanced/design.md): SOQL caching is more complex than it seems. From our perspective, it is much more important to make the code predictable, bug-proof, and intuitive ...
- [Mocking](https://soql.beyondthecloud.dev/cache/advanced/mocking.md): Mocking provides a way to substitute records from a database with some prepared data. Data can be prepared in the form of SObject records and lists...
- [SOQL Cache](https://soql.beyondthecloud.dev/cache/api/soql-cache.md): Apex Classes: `SOQLCache.cls` and `SOQLCache_Test.cls`.
- [Basic Features](https://soql.beyondthecloud.dev/cache/basic-features.md): SOQLCache provides three different cache storage levels, each with different scope and persistence:
- [Building Cached Selector](https://soql.beyondthecloud.dev/cache/build-cached-selector.md): Check examples in the [repository](https://github.com/beyond-the-cloud-dev/soql-lib/tree/main/examples/main/default/classes/cached-selectors).
- [MOCKING](https://soql.beyondthecloud.dev/cache/examples/mocking.md): Mock SOQLCache results in Unit Tests.
- [RESULT](https://soql.beyondthecloud.dev/cache/examples/result.md): For more details check [SOQLCache Cache API - RESULT](../api/soql-cache.md#result).
- [SELECT](https://soql.beyondthecloud.dev/cache/examples/select.md): Specify fields that will be retrieved via query. Check [SOQLCache Cache API - SELECT](../api/soql-cache.md#select).
- [WHERE](https://soql.beyondthecloud.dev/cache/examples/where.md): For more details check [SOQLCache Cache API - WHERE](../api/soql-cache.md#where).
- [Getting Started](https://soql.beyondthecloud.dev/cache/getting-started.md): The SOQL Cache module of the SOQL Lib consists of two concepts: **SOQL Cache Builder** and **SOQL Cached Selectors**.
- [SOQL Evaluator](https://soql.beyondthecloud.dev/evaluator/api/soql-evaluator.md): Apex Classes: `SOQLEvaluator.cls` and `SOQLEvaluator_Test.cls`.
- [Basic Features](https://soql.beyondthecloud.dev/evaluator/basic-features.md): SOQLEvaluator processes static query `List<SObject>` collections. It provides enhanced result transformation methods while keeping your traditional...
- [MOCKING](https://soql.beyondthecloud.dev/evaluator/examples/mocking.md): Mock SOQLEvaluator results in Unit Tests.
- [RESULT](https://soql.beyondthecloud.dev/evaluator/examples/result.md): For more details check [SOQLEvaluator API - RESULT](../api/soql-evaluator.md#result).
- [Getting Started](https://soql.beyondthecloud.dev/evaluator/getting-started.md): The SOQL Evaluator module was created for developers who don't want to learn a new framework but would like to have some benefits like **mocking** ...