I'd like to run a query like this:

$rsm = new ResultSetMappingBuilder($this->em);
$rsm->addRootEntityFromClassMetadata('myBundle:Foo', 'f');
$rsm->addRootEntityFromClassMetadata('myBundle:Bar', 'b');

$sql = 'SELECT l.*, b.*  FROM foos f
        INNER JOIN FROM bars b
        ON b.baz_id = f.baz_id
        WHERE l.bam = 1';

$query = $this->em->createNativeQuery($sql, $rsm);
$fooBarQuery= $query->getResult();

Unfortunately this is not a situation where I can set up a proper relationship in the entity. Is not going to be possible for me to do this? Thanks.