FQL query patterns

Examples of common database operations, including document CRUD operations.

Create, update, and delete collection documents in bulk using FQL queries.

Use user-defined functions (UDFs) to get the user-defined roles assigned to an authentication secret.

Use if …​ else statements to perform conditional operations in Fauna.

Use FQL’s built-in methods to convert, search, and transform Date and Time values.

Use Fauna to run searches in a provided geographic area using a bounding box.

Use FQL’s built-in fold() method to aggregate data in a way similar to SQL’s GROUP BY operation.

Learn how to get unique field values from a Set of documents.

Use string searches to get documents based on a matching string or substring.