Function buildToManyOrderBy

packages/sql/src/AbstractSqlDriver.ts:3362–3394

(
    qb: AnyQueryBuilder<T>,
    prop: EntityProperty<T>,
    path: string,
    ref: string | undefined,
    orderBy: QueryOrderMap<T>[],
  )

  }

  private buildToManyOrderBy<T extends object>(
    qb: AnyQueryBuilder<T>,
    prop: EntityProperty<T>,
    path: string,
    ref: string | undefined,
    orderBy: QueryOrderMap<T>[],
  ): void {
    const join = qb.getJoinForPath(path, { matchPopulateJoins: true });
    const propAlias = qb.getAliasForJoinPath(join ?? path, { matchPopulateJoins: true });

    if (prop.kind === ReferenceKind.MANY_TO_MANY && prop.fixedOrder && join) {
      const alias = ref ? propAlias : join.ownerAlias;
      orderBy.push({ [`${alias}.${prop.fixedOrderColumn}`]: QueryOrder.ASC } as QueryOrderMap<T>);
    }

    const effectiveOrderBy = QueryHelper.mergeOrderBy(prop.orderBy, prop.targetMeta?.orderBy);

    for (const item of effectiveOrderBy) {
      for (const field of Utils.getObjectQueryKeys(item)) {
        const order = item[field as keyof typeof item];

        if (RawQueryFragment.isKnownFragmentSymbol(field)) {
          const { sql, params } = RawQueryFragment.getKnownFragment(field)!;
          const sql2 = propAlias ? sql.replace(new RegExp(ALIAS_REPLACEMENT_RE, 'g'), propAlias) : sql;
          const key = raw(sql2, params);
          orderBy.push({ [key]: order } as QueryOrderMap<T>);
          continue;
        }

        orderBy.push({ [`${propAlias}.${field}` as EntityKey]: order } as QueryOrderMap<T>);
      }
    }
  }

  protected normalizeFields<T extends object>(fields: InternalField<T>[], prefix = ''): string[] {
    const ret: string[] = [];