$query = Doctrine_Query::create()->from('User'); $rows = $query->execute();
$query = Doctrine_Query::create() ->select('u.id, u.username') ->from('User u') ->where('u.created_at > ?', '2019-01-01'); $rows = $query->execute();
$query = Doctrine_Query::create() ->select('u.id, c.name') ->from('User u') ->leftJoin('u.Company c') ->where('u.created_at > ?', '2019-01-01'); $rows = $query->execute();The `Doctrine_Query` class is part of the Doctrine ORM library which is a package library for PHP.