Method processOrderBy

packages/sql/src/query/QueryBuilder.ts:1740–1788

(
    orderBy: QueryOrderMap<Entity> | QueryOrderMap<Entity>[],
    reset = true,
  )

  }

  private processOrderBy(
    orderBy: QueryOrderMap<Entity> | QueryOrderMap<Entity>[],
    reset = true,
  ): SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs> {
    this.ensureNotFinalized();

    if (reset) {
      this.#state.orderBy = [];
    }

    const selectAliases = this.getSelectAliases();

    Utils.asArray<QueryOrderMap<Entity>>(orderBy).forEach(orig => {
      // Shallow clone to avoid mutating the caller's object — safe because the clone
      // is only used within this loop iteration and `orig` is not referenced afterward.
      const o = { ...orig } as Dictionary;

      // Wrap known select aliases in raw() so they bypass property validation and alias prefixing
      for (const key of Object.keys(o)) {
        if (selectAliases.has(key)) {
          o[raw('??', [key]) as any] = o[key];
          delete o[key];
        }
      }

      this.helper.validateQueryOrder(o);
      const processed = QueryHelper.processWhere({
        where: o as FilterQuery<Entity>,
        entityName: this.mainAlias.entityName,
        metadata: this.metadata,
        platform: this.platform,
        aliasMap: this.getAliasMap(),
        aliased: [QueryType.SELECT, QueryType.COUNT].includes(this.type),
        convertCustomTypes: false,
        type: 'orderBy',
      });
      this.#state.orderBy.push(
        CriteriaNodeFactory.createNode<Entity>(this.metadata, this.mainAlias.entityName, processed).process(
          this as IQueryBuilder<Entity>,
          {
            matchPopulateJoins: true,
            type: 'orderBy',
          },
        ),
      );
    });

    return this as SelectQueryBuilder<Entity, RootAlias, Hint, Context, RawAliases, Fields, CTEs>;
  }

  /** Collect custom aliases from select fields (stored as 'resolved as alias' strings by select()). */
  private getSelectAliases(): Set<string> {