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.
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