I have the following type of query to implement:
SELECT DISTINCT a.id as id, a.title as title
FROM one_table a
INNER JOIN related_table b ON a.id = b.item_id
WHERE ...
Looking at Github for IQueryBuilder, I found the method selectAlias. That seems to be what allows to add “SELECT a.id as id, a.title as title”. But not sure if we can pass multiple columns to SelectAlias or call SelectAlias multiple time to add columns.
Also found the method selectDistinct. That seems to be the one to add “SELECT DISTINCT” but not the aliases.
Is it possible to call selectAlias for multiple columns, the selectDistinct with no column just to add the DISTINCT keyword?
AS A WORKAROUND, I USED following syntax
$qb->selectDistinct('a.id as id`, `a.title as title')
->from($this->getTableName(), 'a')
->innerJoin('a', 'related_table', 'b', 'a.id = b.item_id')
->where(...
The trick being to add ` (this is NOT a normal quote ') at the beginning of each column declaration (except first first) and the end of each column declaration (except last), as IQueryBuilder will not quote them.