The QueryBuilder

Hi there,

In Symfony debug tool bar, I am able to get a RUNNABLE query such as below - This is very convenient for me to copy and paste it in any query console and run it manually for debugging purpose.

Runnable query from debug console:

<br />SELECT count(DISTINCT e0_.id) AS sclr_0 FROM estate e0_ INNER JOIN status s1_ ON e0_.status_id = s1_.id INNER JOIN community c2_ ON e0_.community_id = c2_.id INNER JOIN address a3_ ON e0_.address_id = a3_.id INNER JOIN city c4_ ON a3_.city_id = c4_.id INNER JOIN province p5_ ON a3_.province_id = p5_.id INNER JOIN points p6_ ON e0_.id = p6_.estate_id WHERE s1_.current = 'active' AND c2_.name = 'erin woods';<br />

My question is how can I get a RUNNABLE query using var_dump or dump and die dd() within source code? Because not all queries will be shown in Symfony debug tool bar. The best I can do right now is using method ->getDQL() to output the query string of which I have to modify some syntax before I can copy/paste and run it in any query console. An example of ->getDQL() is below, as you can see it is not ready to be executed as sql query.

DQL query from dd($returnQueryResultByCommunityQueryOnly->getDQL()):

<br />SELECT e, s, co, a, c, pr, po FROM App\Entity\Estate e INNER JOIN e.statuses s INNER JOIN e.community co INNER JOIN e.address a INNER JOIN a.city c INNER JOIN a.province pr INNER JOIN e.points po WHERE s.current = 'active' AND co.name = :val ORDER BY po.rank ASC<br />

When I tried with this dump
`
$returnQueryResultByCommunityQueryOnly = $this->addIsActiveQueryBuilder("active")

        ->innerJoin('e.statuses', 's')
        ->addSelect('s')    // avoid repeated queries n+1 problem / bad performance
        ->innerJoin('e.address', 'a')
        ->addSelect('a')
        ->innerJoin('a.city', 'c')
        ->addSelect('c')
        ->innerJoin('e.community', 'com')
        ->addSelect('com')
        ->andWhere('com.name = :val')
        ->setParameter('val', $communityName)
        ->orderBy('e.marketDay', 'ASC')
        ->getQuery();

dd($returnQueryResultByCommunityQueryOnly);
`

I get this dql syntax not 'real' sql, I need to get SQL language:

`
Doctrine\ORM\Query {#9149
-_state: 2
-_parsedTypes: []
-_dql: "SELECT e, s, a, c, com FROM App\Entity\Estate e INNER JOIN e.statuses s INNER JOIN e.address a INNER JOIN a.city c INNER JOIN e.community com WHERE s.current = 'active' AND com.name = :val ORDER BY e.marketDay ASC"
-_parserResult: null
-_firstResult: null
-_maxResults: null
-_queryCache: null
-_expireQueryCache: false
-_queryCacheTTL: null
-_useQueryCache: true
#parameters: Doctrine\Common\Collections\ArrayCollection {#9148

-elements: array:1 [
  0 => Doctrine\ORM\Query\Parameter {#9147
    -name: "val"
    -value: "brentwood"
    -type: 2
  }
]

}
#_resultSetMapping: null
#_em: Doctrine\ORM\EntityManager {#2268 …11}
#_hints: []
#_hydrationMode: 1
#_queryCacheProfile: null
#_expireResultCache: false
#_hydrationCacheProfile: null
#cacheable: false
#hasCache: false
#cacheRegion: null
#cacheMode: null
#cacheLogger: null
#lifetime: 0
}
`

Thank you!