<?php

use PHPSnippets\Db\Entity\Test;
use Doctrine\ORM\Query;
use Doctrine\ORM\QueryBuilder;
use Doctrine\ORM\Tools\Pagination\Paginator;

function paginate(QueryBuilder $qb, $firstResult, $maxResult)
{
    $qb->setFirstResult((int) $firstResult)
        ->setMaxResults((int) $maxResult);
    
    $paginator = new Paginator($qb->getQuery(), true);
    
    return $paginator;
}

$qb = $entityManager->createQueryBuilder();
$qb->select('t')
    ->from(Test::CLASS, 't');

foreach (paginate($qb, 0, 2) as $entity) {
    echo $entity->id . ', ' . $entity->name . PHP_EOL;
}

1, foo
2, test

• Create your own Doctrine function
• Individual data structure in Doctrine with custom Hydrators
• Closure content executed as transaction in Doctrine DBAL

PHP 8.3, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8