<?php

use PHPSnippets\Db\Entity\Test;

class Foo
{
    private $number;
    private $name;
    
    public function __construct(int $id, string $name)
    {
        $this->number = $id * 1000;
        $this->name = $name . 'ly';
    }
}

$result = $entityManager->createQuery(
    'SELECT NEW Foo(test.id, test.name) FROM '.Test::class.' test'
)->getResult();

dump($result);

^ array:3 [

  0 => Foo {#1415

    -number: 1000

    -name: "fooly"

  }

  1 => Foo {#1416

    -number: 2000

    -name: "testly"

  }

  2 => Foo {#1417

    -number: 3000

    -name: "barly"

  }

]

• get a partial reference in Doctrine
• Transform result rows into another format in Doctrine DBAL
• Doctrine DBAL events on database table creation

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