Method getNativeQuery

packages/sql/src/query/QueryBuilder.ts:2151–2237

(processVirtualEntity = true)

  }

  getNativeQuery(processVirtualEntity = true): NativeQueryBuilder {
    if (this.#state.unionQuery) {
      if (!this.#query?.qb) {
        this.#query = {} as any;
        const nqb = this.platform.createNativeQueryBuilder();
        nqb.select('*');
        nqb.from(raw(`(${this.#state.unionQuery.sql})`, this.#state.unionQuery.params));
        this.#query!.qb = nqb;
      }

      return this.#query!.qb;
    }

    if (this.#query?.qb) {
      return this.#query.qb;
    }

    this.#query = {} as any;
    this.finalize();
    const qb = this.getQueryBase(processVirtualEntity);

    for (const cte of this.#state.ctes) {
      const query = cte.query;
      const opts: CteOptions = { columns: cte.columns, materialized: cte.materialized };

      if (cte.recursive) {
        qb.withRecursive(cte.name, query, opts);
      } else {
        qb.with(cte.name, query, opts);
      }
    }

    const schema = this.getSchema(this.mainAlias);
    const isNotEmptyObject = (obj: Dictionary) => Utils.hasObjectKeys(obj) || RawQueryFragment.hasObjectFragments(obj);

    Utils.runIfNotEmpty(
      () => this.helper.appendQueryCondition(this.type, this.#state.cond, qb),
      this.#state.cond && !this.#state.onConflict,
    );
    Utils.runIfNotEmpty(
      () => qb.groupBy(this.prepareFields(this.#state.groupBy, 'groupBy', schema)),
      isNotEmptyObject(this.#state.groupBy),
    );
    Utils.runIfNotEmpty(
      () => this.helper.appendQueryCondition(this.type, this.#state.having, qb, undefined, 'having'),
      isNotEmptyObject(this.#state.having),
    );
    Utils.runIfNotEmpty(() => {
      const queryOrder = this.helper.getQueryOrder(
        this.type,
        this.#state.orderBy as FlatQueryOrderMap[],
        this.#state.populateMap,
        this.#state.collation,
      );

      if (queryOrder.length > 0) {
        const sql = Utils.unique(queryOrder).join(', ');
        qb.orderBy(sql);