Method having

packages/sql/src/query/QueryBuilder.ts:1872–1900

* Adds a HAVING clause to the query, typically used with GROUP BY. * * @example * ```ts * qb.select([raw('count(*) as count'), 'status']) * .groupBy('status') * .having({ count: { $gt: 5 } }); * ```

(
    cond: QBFilterQuery<Entity, RootAlias, Context, RawAliases> | string = {},
    params?: any[],
    operator?: keyof typeof GroupOperator,
  )

   * ```
   */
  having(
    cond: QBFilterQuery<Entity, RootAlias, Context, RawAliases> | string = {},
    params?: any[],
    operator?: keyof typeof GroupOperator,
  ): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs> {
    this.ensureNotFinalized();

    if (typeof cond === 'string') {
      cond = { [raw(`(${cond})`, params)]: [] } as QBFilterQuery<Entity, RootAlias, Context, RawAliases>;
    }

    const processed = CriteriaNodeFactory.createNode<Entity>(
      this.metadata,
      this.mainAlias.entityName,
      cond as FilterQuery<Entity>,
      undefined,
      undefined,
      false,
    ).process(this as IQueryBuilder<Entity>, { type: 'having' });

    if (!this.#state.having || !operator) {
      this.#state.having = processed as FilterQuery<Entity>;
    } else {
      const cond1 = [this.#state.having, processed];
      this.#state.having = { [operator]: cond1 };
    }

    return this as SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs>;
  }

  andHaving(
    cond?: QBFilterQuery<Entity, RootAlias, Context, RawAliases> | string,