OFFSET n ROWS FETCH NEXT n ROWS ONLY seems to be fairly standard so supporting :offset and :fetch seems reasonable in for-query.
SELECT TOP n is specific to SQL Server I believe but supporting :top is not confusing, and it's easy.
LIMIT ? OFFSET ? is supported by MySQL and PostgreSQL (which also supports the offset/fetch syntax above) so supporting :limit is also worthwhile (and the presence of :limit would determine which :offset syntax to use).
OFFSET n ROWS FETCH NEXT n ROWS ONLY
seems to be fairly standard so supporting:offset
and:fetch
seems reasonable infor-query
.SELECT TOP n
is specific to SQL Server I believe but supporting:top
is not confusing, and it's easy.LIMIT ? OFFSET ?
is supported by MySQL and PostgreSQL (which also supports the offset/fetch syntax above) so supporting:limit
is also worthwhile (and the presence of:limit
would determine which:offset
syntax to use).