thank @vsr1 and wow @binh.le, it’s an old ticket so I wish I could be more hopeful but this would be a huge improvement.
allowing users to sort on relatively arbitrary fields and supporting arbitrary order is a common use and to support push down paging to for the access patterns requires permutations of indexes.