Native SQL pagination?

Question

Doctrine ORM

In DQL

$query
                    ->setFirstResult($pagination->offset())
                   ->setMaxResults($pagination->limit())
              ;

And in SQL? I don't see anything in the docks.
Ready solutions?