$domain = Doctrine_Query::create()
    ->from( "Domain d" )
    ->where("d.name = ?", $name)
    ->setHydrationMode(Doctrine::HYDRATE_ARRAY);

echo $domain->getSql();

$domain = $domain->execute();