Equality in a WHERE clause. PhiSQL writes equality as =, and it compiles to

Source: confidence-equals.phisql (spec v1.3.0)

PhiSQL

-- Equality in a WHERE clause. PhiSQL writes equality as `=`, and it compiles to
-- the Phileas condition operator `==` (RFC #58); earlier compilers emitted `=`,
-- which the Java and .NET runtimes could not evaluate. Predicates joined with
-- AND compile to `and`. The last statement has no WHERE, so a value that meets
-- neither condition is still redacted: without it, that value would be left
-- unchanged (RFC #57). Compiles to confidence-equals.json.

POLICY confidence_equals;

REDACT SSN WITH LAST_4 WHERE CONFIDENCE = 1.0;
REDACT SSN WITH MASK WHERE CONFIDENCE >= 0.5 AND CONFIDENCE < 1.0;
REDACT SSN WITH REDACT;

Compiles to

{
  "identifiers": {
    "ssn": {
      "ssnFilterStrategies": [
        {
          "strategy": "LAST_4",
          "condition": "confidence == 1.0"
        },
        {
          "strategy": "MASK",
          "condition": "confidence >= 0.5 and confidence < 1.0"
        },
        {
          "strategy": "REDACT"
        }
      ]
    }
  }
}