Method withSubQuery

packages/sql/src/query/QueryBuilder.ts:1507–1517

(subQuery: RawQueryFragment | NativeQueryBuilder, alias: string)

  }

  withSubQuery(subQuery: RawQueryFragment | NativeQueryBuilder, alias: string): this {
    this.ensureNotFinalized();

    if (isRaw(subQuery)) {
      this.#state.subQueries[alias] = this.platform.formatQuery(subQuery.sql, subQuery.params);
    } else {
      this.#state.subQueries[alias] = subQuery.toString();
    }

    return this;
  }

  /**
   * Adds a WHERE clause to the query using an object condition.