Object-Relational Mappers

SQL provides a powerful tool for querying data, but the records we get in the result are just plain key-value arrays with scalar values inside. Also, we have to write SQL commands to update and query data. That’s database-specific logic, and we might want to keep it separate from application logic.

When we query theater plays from the database, we want to retrieve an array of Play objects instead of plain arrays. In this case, we can be sure of our data structure and use the Play class methods. When we update a play, we usually want to update some properties in the Play object instead of composing an SQL command.

We can solve this with an object-relational mapper (ORM), an abstraction layer that translates data between our objects and the database. To developers, ORMs seem like magical databases that understand our objects. And, it uses the actual database in the background.

The most popular ORM in PHP according to the Packagist repository is Doctrine ORM. This lesson was mostly written with Doctrine in mind. Things might be slightly different with other ORMs.

How ORM works