Method mergeOnConditions

packages/sql/src/query/QueryBuilder.ts:3865–3904

(joins: JoinOptions[], cond: Dictionary, filter: boolean, op?: string)

  }

  private mergeOnConditions(joins: JoinOptions[], cond: Dictionary, filter: boolean, op?: string) {
    for (const k of Object.keys(cond)) {
      if (Utils.isOperator(k)) {
        if (Array.isArray(cond[k])) {
          cond[k].forEach((c: Dictionary) => this.mergeOnConditions(joins, c, filter, k));
        }

        /* v8 ignore next */
        this.mergeOnConditions(joins, cond[k], filter, k);
      }

      const [alias] = this.helper.splitField(k as EntityKey<Entity>);
      const join = joins.find(j => j.alias === alias);

      if (join) {
        const parentJoin = joins.find(j => j.alias === join.ownerAlias);

        // https://stackoverflow.com/a/56815807/3665878
        if (parentJoin && !filter) {
          const nested = (parentJoin.nested ??= new Set());
          join.type =
            join.type === JoinType.innerJoin ||
            [ReferenceKind.ONE_TO_MANY, ReferenceKind.MANY_TO_MANY].includes(parentJoin.prop.kind)
              ? JoinType.nestedInnerJoin
              : JoinType.nestedLeftJoin;
          nested.add(join);
        }

        if (join.cond[k]) {
          /* v8 ignore next */
          join.cond = { [op ?? '$and']: [join.cond, { [k]: cond[k] }] };
        } else if (op === '$or') {
          join.cond.$or ??= [];
          join.cond.$or.push({ [k]: cond[k] });
        } else {
          join.cond = { ...join.cond, [k]: cond[k] };
        }
      }
    }
  }

  /**
   * When adding an inner join on a left joined relation, we need to nest them,