Is there any possible way to use PHQL and join a custom subquery to the resultset? Now PHQL throws the exception points right to the subquery.
$this->modelsManager->createBuilder()
->from('Robots')
->join('RobotsParts')
->join('(SELECT 0 as number)', null, 'p')
->orderBy('Robots.name')
->getQuery()
->execute();