Skip to main content
The SQL filter evaluates a boolean expression against each datapoint. You write the body of a WHERE clause without the word WHERE itself — for example, Age > 20.
Which syntax applies depends on the sourceThis reference documents the expression dialect that Validio’s own engine evaluates, which applies to non-SQL sources such as data streams.For SQL sources — data warehouses, query engines, and transactional databases — the filter expression is evaluated by that system in its own SQL dialect. Refer to the documentation for your data source instead.
For how to configure a SQL filter on either kind of source, see SQL Filter. To compose an expression with an LLM instead of writing it by hand, see Generating SQL in Validators and Filters. The filter editor verifies your expression against the source as you write, reporting syntax and field errors. Filters have no sample-row preview, unlike the custom SQL source and Custom SQL validator editors.

Data types

Similar data types map internally to the same json type. For example, CASTing a value to INT has the same effect as CASTing the same value to Float. The following data types are supported:

Arithmetic functions

Comparison functions

Conditional functions

Filter functions

Logical functions

String functions

Type conversion functions

Allowed type conversions

Data reference functions

Comments

SQL filter query syntax only supports comments using the following multi-line syntax, /* your_comment */. For example,
SQL