Adding GROUP BY expression

Adding a GROUP BY expression is easy as:

createQueryBuilder("user").groupBy("user.id")

Which will produce the following SQL query:

SELECT ... FROM users user GROUP BY user.id

To add more group-by criteria use addGroupBy:

createQueryBuilder("user").groupBy("user.name").addGroupBy("user.id")

If you use .groupBy more than once you’ll override all previous GROUP BY expressions.