REST Pagination techniques

My thoughts had always been that pagination was straightforward — just throw in a LIMIT and OFFSET...