So far, we have learned how Magento data models and the ORM system provide a clean and simple way to access, store, and manipulate our data. Before we jump right into this section, learn about the Magento database adapters, and how to run raw SQL queries, I feel it is important that we understand why you should avoid as much as possible to use what you are about to learn in this section.
Magento is an extremely complex system, and as we've also learned in the previous chapter, a framework is driven in part by events; just saving a product will trigger different events, each doing a different task. This will not happen if you decide to just create a query and update a product directly. So, as developers, we have to be extremely careful and sure whether there is a justifiable reason for going outside the ORM.
That said, there are, of course, scenarios when being able to work with the database directly comes in extremely handy and is actually simpler than working with the Magento...