Subquery in select clause in symfony2 in select clause
I want to use symfony2 query builder in repository, to create following
query:
SELECT c.name,
(
SELECT COUNT(1)
FROM product
WHERE product.cat_id = c.id
) products
FROM category c
ORDER BY category.id ASC
May I use query builder for this purpose, and how to structure query
builder? Thanks
