Using Pagination Library

I just use pagination via model ; what i can't see in yours anywhere is including 

Code:

->paginate(10);

I'm aware of this. But the problem is that you can't paginate results of a query builder. If you do something like this:

PHP Code:

$query_posts = $db->query("SELECT * FROM posts ORDER BY created_at DESC")->paginate(3); 


the following error will be raised: Call to undefined method CodeIgniter\Database\SQLite3\Result::paginate().

I don't want to use the <post> model to retrieve records from database. In other words: Is it possible to paginate the results of a query builder?