In a general form, a mql query defines a condition which must be satisfied and any resource not
satisfying this condition will be eliminated from output.
A condition is any expression that evaluates to a result of type boolean.
- and
- or
- eq:
= - gte:
>= - gt:
> - lte:
<= - lt:
< - ne:
!= - lparen:
( - rparen:
) - contains:
% - string:
example - quote:
"
<comparison expr> | <logical expr>
(lparen)? <column> (<whitespace>)? <comparison operator> (<whitespace>)? <value> (<rparen)?
(lparen)? <logical expr> | <comparison expr> <logical operator> <logical expr> | <comparison expr> (<rparen)?
- <string>
- <string>
A string delimited by quotes. You can escape quotes with a backslash \" and
you can escape a backslash with a second backslash \\ . Supported delimiters:
double-quotes, single-quotes, backtick.
- <quote> <string> <quote>
A string (quoted or not) which is the value of a column used in a comparison expr. The string must be a valid value/type for the column which will be enforced by the RDBMS when the query is executed.
- <string>
An identifier string token that forms a column name and must match a name in the Go struct used in conjunction with the query and of course it must be a valid column name for the resource being queried in the RDBMS.
- <symbol>
- <eq>
- <gte>
- <gt>
- <lte>
- <lt>
- <ne>
- <and>
- <or>