Metabase query language brainstorming

gistfile1.txt

head2 Constraints

  [ FIELD => OPERATOR => EXPRESSION ]

  [ -or => [CONSTRAINT1, CONSTRAINT2, ...] ]

  [ -and => [CONSTRAINT1, CONSTRAINT2, ...] ]

  [ -not => CONSTRAINT ]

=head2 Operators and expressions

  COMPARATOR => VALUE         # Any of == != > >= < <=

  -between => VALUE1, VALUE2  # >= VALUE 1 and <= VALUE2

  -like => PATTERN            # where '%' is like regex '.+'

=head2 Ordering

  -asc  => FIELD
  -asc  => [ FIELD1, FIELD2 ]
  -desc => FIELD
  -desc => [ FIELD1, FIELD2 ]

=head2 Limit results

  -limit => NUMBER