[Simple Query] Add the ability for paging,

By Robert Chanphakeo on 29 May
Add the ability for paging should be a core feature built into simple query widget (Instead of having to create an "Advance SQL Query" with paging like this - for every single get record list query!)

MySQL: 
SELECT * FROM {Country} ORDER BY {Country}.[Name] LIMIT 25 OFFSET 25 

ORACLE/SQL Server
SELECT * FROM  {Country} ORDER BY  {Country}.[Name] OFFSET 25 ROWS FETCH NEXT 25 ROWS ONLY;

Note: When you build a web service more than likely you would add a get record list web service, and these services would require
 paging (Limit, Offset), all popular web services contain paging from facebook, twitter, linkedin, google etc
You can set the Record Limit on the Query

Rebecca, you can not do paging with record limit. The query needs to know where to start (offset)