Sorting feature of this package is in its infancy and subject to changes.
$sql = Product::sort([
    [
        'target' => 'name',
        'value'  => 'desc',
    ],
])->toRawSql();

select * from "products" order by "name" desc