Method groupBy

packages/sql/src/query/QueryBuilder.ts:1843–1860

(fields: unknown)

    fields: NestedAutoPath<Entity, RootAlias, Context, P> | readonly NestedAutoPath<Entity, RootAlias, Context, P>[],
  ): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs>;
  groupBy(fields: unknown): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs> {
    this.ensureNotFinalized();
    this.#state.groupBy = Utils.asArray(
      fields as Field<Entity, RootAlias, Context> | readonly Field<Entity, RootAlias, Context>[],
    ).flatMap(f => {
      if (typeof f !== 'string') {
        // Normalize sql.ref('prop') to string for proper formula resolution
        if (isRaw(f) && f.sql === '??' && f.params.length === 1) {
          return this.resolveNestedPath(String(f.params[0]));
        }

        return f;
      }
      return this.resolveNestedPath(f);
    }) as any;

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

  /**
   * Adds a HAVING clause to the query, typically used with GROUP BY.