Method buildCondition

packages/db/src/clickhouse/query-builder.ts:158–182

(
    column: string,
    operator: Operator,
    value?: SqlParam
  )

  }

  public buildCondition(
    column: string,
    operator: Operator,
    value?: SqlParam
  ): string {
    switch (operator) {
      case 'IS NULL':
        return `${column} IS NULL`;
      case 'IS NOT NULL':
        return `${column} IS NOT NULL`;
      case 'BETWEEN':
        if (Array.isArray(value) && value.length === 2) {
          return `${column} BETWEEN ${this.escapeValue(value[0]!)} AND ${this.escapeValue(value[1]!)}`;
        }
        throw new Error('BETWEEN operator requires an array of two values');
      case 'IN':
      case 'NOT IN':
        if (!(Array.isArray(value) || value instanceof Expression)) {
          throw new Error(`${operator} operator requires an array value`);
        }
        return `${column} ${operator} ${this.escapeValue(value)}`;
      default:
        return `${column} ${operator} ${this.escapeValue(value!)}`;
    }
  }

  andWhere(column: string, operator: Operator, value?: SqlParam): this {
    const condition = this.buildCondition(column, operator, value);