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
