Operators and Functions

Operators and functions can be used to transform columns/fields before being synced to a client.

When filtering on parameters (token or client parameters in the case of parameter queries, and bucket parameters in the case of data queries), operators can only be used in a limited way. Typically only = , IN and IS NULL are allowed on the parameters, and special limits apply when combining clauses with AND, OR or NOT. The exact rules are still being refined — make sure to validate and test the Sync Rules.

When transforming output columns/fields, or filtering on row/document values, those restrictions do not apply.

If a specific operator or function is needed, please contact us so that we can consider inclusion in our roadmap.

Some fundamental restrictions on these operators and functions are:

  1. It must be deterministic — no random or time-based functions.

  2. No external state can be used.

  3. It must operate on data available within a single row/document. For example, no aggregation functions allowed.

Operators

Functions

Most of these functions are based on the built-in SQLite functions and SQLite JSON functions.

Last updated