Custom Query: Paging and Sorting

I thought I saw this topic awhile back but can’t seem to find it.

How would one go about adding paging and column sorting to a custom query?