How to work with SQL VIEW in Doctrine?

Question

PHP

I can't figure out how to use ready-made SQL VIEWs in Doctrine 2? The same goes for SQL procedures. Everything is already in the database and there is no need to generate it in Doctrine, you only need to use it to get data.

I ask you to tell me in which direction to dig, I only found the option of creating a view in the code , maybe there is a function to get the SQL code by the name of the view, or I don’t understand something fundamentally?

Answer 1

To work with procedures and views, I used NativeSQL. In order not to write your own table mapping, you can use the @EntityResult annotation. In general, you can think of many different ways, but I think there is not much point in this.