Class QueryBuilder

packages/sql/src/query/QueryBuilder.ts:587–4405

 * ```
 */
export class QueryBuilder<
  Entity extends object = AnyEntity,
  RootAlias extends string = never,
  Hint extends string = never,
  Context extends object = never,
  RawAliases extends string = never,
  Fields extends string = '*',
  CTEs extends Record<string, object> = {},
> implements Subquery {
  declare readonly __subquery: true;

  #state: QBState<Entity> = QueryBuilder.createDefaultState<Entity>();
  #helper?: QueryBuilderHelper;
  #query?: { sql?: string; params?: readonly unknown[]; qb: NativeQueryBuilder };
  #abortOptions?: AbortQueryOptions;

  /** @internal */
  static createDefaultState<T extends object>(): QBState<T> {
    return {
      aliasCounter: 0,
      explicitAlias: false,
      populateHintFinalized: false,
      joins: {},
      cond: {},
      orderBy: [],
      groupBy: [],
      having: {},
      comments: [],
      hintComments: [],
      subQueries: {},
      aliases: {},
      tptAlias: {},
      ctes: [],
      tptJoinsApplied: false,
      autoJoinedPaths: [],
      populate: [],
      populateMap: {},
      flags: new Set([QueryFlag.CONVERT_CUSTOM_TYPES]),
      finalized: false,
      joinedProps: new Map(),
    };
  }

  get mainAlias(): Alias<Entity> {
    this.ensureFromClause();
    return this.#state.mainAlias!;
  }

  get alias(): string {
    return this.mainAlias.aliasName;
  }

  get helper(): QueryBuilderHelper {
    this.ensureFromClause();
    return this.#helper!;
  }

  get type(): QueryType {