Can DBAL be mixed with ORM Query Builder?

Question

I am trying to create a query builder using ORM. But I come across a field on entities with relation to two possible tables. With this structure it would be (IMHO) impossible to match it in the entity itself.

╔═══════╗ ╔═══════╗ ╔═══════╗ ║ ValB ║ ║ Main ║ ║ ValC ║ ╠══╦════╣ ╠══╦════╣ ╠══╦════╣ ║ *║ pk ║-- + ║ *║ pk ║ +---║ *║ pk ║ ╠══╬════╣ | ╠══╬════╣ | ╠══╬════╣ ║ ║ ║ +--║ ║v_id║---+ ║ ║ ║ ╠══╬════╣ ╠══╬════╣ ╠══╬════╣ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══╩════╝ ╚══╩════╝ ╚══╩════╝ 

Is it possible to mix DBAL QueryBuilder with ORM QueryBuilder or in any other way that will still use ORM QueryBuilder mainly in code.

PS. I did not design db and im just optimizing it. sorry for that: (

Answer 1

No, this does not make sense, because later the ORM should map the results to objects. You cannot match both ValB and ValC with the same property in Main

To do this correctly, the Main table must have separate fields for the ValB and ValC . Even if they have the same meaning. Like this

 ╔═══════╗ ╔════════╗ ╔═══════╗ ║ ValB ║ ║ Main ║ ║ ValC ║ ╠══╦════╣ ╠══╦═════╣ ╠══╦════╣ ║ *║ pk ║-- + ║ *║ pk ║ +---║ *║ pk ║ ╠══╬════╣ | ╠══╬═════╣ | ╠══╬════╣ ║ ║ ║ +--║ ║vB_id║ | ║ ║ ║ ╠══╬════╣ ╠══╬═════╣ | ╠══╬════╣ ║ ║ ║ ║ ║vC_id║---+ ║ ║ ║ ╚══╩════╝ ╚══╩═════╝ ╚══╩════╝ 

You can copy the v_id column and then do the correct mapping in Doctrine.