Sort by nested fields

is sorting / filtering by nested fields possible?

use case
table in UI, which is based on multiple DB collections,
needs to support sorting by every single field

for example
if the table queries Users as such

  users {
    name
    pets { kind }
  }

I need to sort the results, by the kind of pet,
is it possible?

I have same question ?
Is any solution exist ?