Mikro orm sortable columns excluding relations

example.js

if (params.sort.length) {
  // entity-level sortable columns only, doesn't include relationships
  const sortableColumns: string[] = filter(
    this.em.getMetadata(PicklistProductEntity.name).properties,
    ({ reference }) => reference === 'scalar'
  ).map(({ name }) => name);

  if (params.sort.every((sort) => sortableColumns.includes(sort))) {
    options.orderBy = params.sort.reduce((acc, key, i) => {
      acc[key] = params.sortDirection
        ? params.sortDirection[i]
        : SortDirection.ASC;
      return acc;
    }, {});
  } else {
    throw new BadRequestException(
      `Invalid sort column. Must be in ${sortableColumns}`
    );
  }
} else {
  options.orderBy = {
    id: SortDirection.ASC,
  };
}