Support fallback column for sorting when the value is NULL

[tripss]

Support fallback column for sorting when the value is NULL

[TriPSs]

How would you propose to fit this inside the Query<T>?

[ValentinVignal]

What about something like

sorting = [
  {
    field: 'actualStartDate'
    fieldFallback: {
      field: 'plannedStartDate'
    }
]

The typing could be:

export interface FallbackSortField<T> {
  field: keyof T;
  fieldFallback: FallbackSortField<T>;
}

export interface SortField<T> extends FallbackSortField<T> {
  direction: SortDirection;
  nulls?: SortNulls;
}

What do you think?