cubicweb #1154756 SQL Server support : do not use LIMIT and OFFSET keywords in generated SQL [resolved]
rql2sql should use an abstraction for LIMIT/OFFSET syntax (to be added in logilab.database).
ms sql supports "SELECT TOP(10) * FROM table" which is very similar to "SELECT * FROM table LIMIT 10"
OFFSET is not supported AFAIK, but see http://msdn.microsoft.com/en-us/library/ms979197
|closed by||#bcdf22734059 Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation|