Cakephp: how to implement custom pagination?

Question

As in using pagination for custom SQL query

Answer 1

CakePHP has a rather detailed documentation on this very issue: Custom Query Pagination.