API should support pagination

The API doesn't have support for pagination. It already supports limiting the result set by the "limit" parameter, but there's no way to set a start. This is important for projects which want to do pagination based on the API; right now I solve that using an emulated pagination, which is neither nice nor performant. The database should do the work if supported, and if not, the API should fall back to an emulation.