Method wrapModifySubQuery

packages/sql/src/query/QueryBuilder.ts:4248–4266

(meta: EntityMetadata)

  }

  private wrapModifySubQuery(meta: EntityMetadata): void {
    const subQuery = this.clone();
    subQuery.#state.finalized = true;

    // wrap one more time to get around MySQL limitations
    // https://stackoverflow.com/questions/45494/mysql-error-1093-cant-specify-target-table-for-update-in-from-clause
    const subSubQuery = this.platform.createNativeQueryBuilder();
    const method = this.#state.flags.has(QueryFlag.UPDATE_SUB_QUERY) ? 'update' : 'delete';
    const schema = this.getSchema(this.mainAlias);
    const pks = this.prepareFields(meta.primaryKeys, 'sub-query', schema) as string[];
    this.#state.cond = {}; // otherwise we would trigger validation error
    this.#state.joins = {}; // included in the subquery
    subSubQuery.select(pks).from(subQuery.as(this.mainAlias.aliasName));

    const { sql, params } = subSubQuery.compile();
    ((this[method] as (data?: unknown) => RunQueryBuilder<Entity>)(this.#state.data).where as any)({
      [Utils.getPrimaryKeyHash(meta.primaryKeys)]: { $in: raw(sql, params) },
    });
  }

  private getSchema(alias: Alias<any>): string | undefined {
    const { meta } = alias;