Function isComparisonOp

packages/electric-db-collection/src/sql-compiler.ts:390–393

* Check if operator is a comparison operator that takes two values * These operators cannot accept null/undefined as values * (null comparisons in SQL always evaluate to UNKNOWN)

(name: string)

 * (null comparisons in SQL always evaluate to UNKNOWN)
 */
function isComparisonOp(name: string): boolean {
  const comparisonOps = [`eq`, `gt`, `gte`, `lt`, `lte`, `like`, `ilike`]
  return comparisonOps.includes(name)
}

/**
 * Checks if the operator is a comparison operator (excluding eq)