Is there a way to override the method of the pagination for SQL Server in Illuminate\Database\Query\Grammars\SqlServerGrammar.php to use the Offset-Fetch?

I'm running into problems in some of my queries where there are aggregates and being able to sort by them does not play nice with the row_number() function without some workarounds.

In some cases, like on the users list, the sort is out of sync with a basic query because the first page uses the query with limit, whereas page n uses the row_number() with a where clause. The issue I see on this is an entry from the 1st page is on the 2nd page.

Any help would be greatly appreciated!