TSQL Offset issue

[bisoftbilgi]

I am triying to transpile a sql from postgresql to tsql however offset seems not working in the tsql dialect. Is there a way to make offset work in the tsql

PostgreSQL query
SELECT "tvf"."logo", "tvf"."takim", SUM("tvf"."oynanan_mac"), SUM("tvf"."kazanilan_mac"), SUM("tvf"."maglubiyet"), SUM("tvf"."kazanilan_set"), SUM("tvf"."kaybedilen_set"), SUM("tvf"."set_averaj"), SUM("tvf"."sayi_averaj"), SUM("tvf"."siralama_puani") FROM tvf WHERE 1 = 1 AND kazanilan_mac >= 25 GROUP BY "tvf"."logo", "tvf"."takim" LIMIT 100 OFFSET 50

Transpiled TSQL query
SELECT TOP 100 "tvf"."logo", "tvf"."takim", SUM("tvf"."oynanan_mac"), SUM("tvf"."kazanilan_mac"), SUM("tvf"."maglubiyet"), SUM("tvf"."kazanilan_set"), SUM("tvf"."kaybedilen_set"), SUM("tvf"."set_averaj"), SUM("tvf"."sayi_averaj"), SUM("tvf"."siralama_puani") FROM tvf WHERE 1 = 1 AND kazanilan_mac >= 25 GROUP BY "tvf"."logo", "tvf"."takim"

[georgesittas]

This is out of scope for us right now, happy to accept a high-quality PR. One thing to note is that T-SQL seems to require an ORDER BY clause in order to use OFFSET / FETCH, which is documented in https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15#using-offset-and-fetch-to-limit-the-rows-returned.

So if there's no ORDER BY clause in the source query, I don't think it's reasonable to arbitrarily pick a sort key to order by just so that we can transpile this. If there is an ORDER BY clause, then maybe it's possible.