Append Offset

[cryo75]

Add the ability to append the offset using the following sql:

OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY

where {0} is the number of rows to skip and {1} is the number of results to return.

[maxtoroq]

You can do it already:

var query = SQL
   .SELECT("*")
   .FROM("Products")
   .ORDER_BY("ProductID")
   .OFFSET("{0} ROWS FETCH NEXT {1} ROWS ONLY", startIndex, pageSize);