SQL-like query language for csv

Operator Precedence

The following table list operators from highest precedence to lowest.

precedence operators associativity
1 + (unary plus) Right-to-left
  - (unary minus) Right-to-left
  ! Right-to-left
2 * Left-to-right
  / Left-to-right
  % Left-to-right
3 + Left-to-right
  - Left-to-right
4 || Left-to-right
5 = nonassoc
  == nonassoc
  < nonassoc
  <= nonassoc
  > nonassoc
  >= nonassoc
  <> nonassoc
  != nonassoc
  IS nonassoc
  BETWEEN nonassoc
  IN nonassoc
  LIKE nonassoc
6 NOT Right-to-left
7 AND Left-to-right
8 OR Left-to-right
9 INTERSECT Left-to-right
10 UNION Left-to-right
  EXCEPT Left-to-right
11 := Right-to-left