How to refer to a table if an entity has not been created for it?

Question

Doctrine ORM

I make a query through createQueryBuilder
there is a related table, how can I join it, if you just specify its name, then it gives errors

Answer 1

If you need Doctrine mapping as a result of a query, then you will have to create an entity for the associated table. And if you want to get just an array of data, then you can ask the EntityManager for a connection and execute a plain SQL query. Within DQL, it's either all or nothing. Partially will not work