Pagination Support for all the GET ALL APIs

[bipoool]

We should add support for Pagination in all the GET ALL APIs as returning all the rows in 1 go won't scale

-- Example with pagination support
SELECT id, name, display_name, description, label, ansible_role, parameters, created_at, updated_at 
FROM components 
ORDER BY created_at DESC 
LIMIT $1 OFFSET $2;