Method addCte

packages/sql/src/query/QueryBuilder.ts:2874–2897

(
    name: string,
    query: QueryBuilder<any> | NativeQueryBuilder | RawQueryFragment,
    options?: CteOptions,
    recursive?: boolean,
  )

  }

  private addCte(
    name: string,
    query: QueryBuilder<any> | NativeQueryBuilder | RawQueryFragment,
    options?: CteOptions,
    recursive?: boolean,
  ): this {
    this.ensureNotFinalized();

    if (this.#state.ctes.some(cte => cte.name === name)) {
      throw new Error(`CTE with name '${name}' already exists`);
    }

    // Eagerly compile QueryBuilder to RawQueryFragment — later mutations to the sub-query won't be reflected
    const compiled = query instanceof QueryBuilder ? query.toRaw() : query;
    this.#state.ctes.push({
      name,
      query: compiled,
      recursive,
      columns: options?.columns,
      materialized: options?.materialized,
      meta: query instanceof QueryBuilder ? query.mainAlias.meta : undefined,
    });
    return this;
  }

  clone(
    reset?: boolean | (keyof QBState<Entity>)[],