I am struggling to find a way to use query builder to select data from a table which is not a table of some entity. method ->from() takes only class name (entity name) as a parameter. something like:
$qb->select('t.id')
->from('table_not_entity_name')
->andWhere('t.isActive = :isActive')
->setParameter('isActive', 1);
I also need to join a table of entity to an another table.
$qb->select('category.id')
->join("t.table_name", 'category')
->distinct();
Is there a way?