Skip to main content


Operators are methods on the dialect's Expression. There are a number of common operators shared by all supported dialects:

  • IsNull(): X IS NULL
  • IsNotNull(): X IS NOT NULL
  • IsDistinctFrom(y any): X IS DISTINCT FROM Y
  • IsNotDistinctFrom(y any): X IS NOT DISTINCT FROM Y
  • Minus(y any): X - Y
  • OP(op string, y any): X op Y -- for custom operators
  • EQ(y any): X = Y
  • NE(y any): X \<> Y
  • LT(y any): X \< Y
  • LTE(y any): X \<= Y
  • GT(y any): X > Y
  • GTE(y any): X >= Y
  • In(...any): X IN (y, z)
  • NotIn(...any): X NOT IN (y, z)
  • Or(y any): X OR Y
  • And(y any): X AND Y
  • Concat(y any): X || Y
  • Between(y, z any): X BETWEEN Y AND Z
  • NotBetween(y, z any): X NOT BETWEEN Y AND Z

The following expressions cannot be chained and are expected to be used at the end of a chain

  • As(alias string): X as "alias". Used for aliasing column names

See dialect documentation for extra operators