sql - symfony 嵌套查询

Question

如何使用 symfony 和教义 queryBuilder 执行嵌套查询？例如：

select data.name from
(
  select case when name = 'Alfred' then 'Thomas' else name end as name
  from employee
) as data;

谢谢

标签： sqlsymfonydoctrine

Answer 1

我使用本机 sql 解决了：

    $stmt = $this->doctrine->getConnection()->prepare('your_query');
    $stmt->execute();
    $res = $stmt->fetchAll();