MODX Lead Architect, Jason Coward aka opengeek details the benefits of using xPDO (the technology that connects MODX to databases) over SQL directly.
There are several benefits to using xPDO versus writing direct SQL. I have enumerated these in various places before, but let's collect them all in one place.
- Better Upgrade Path Protection
- Easily Write Database Agnostic Code
- Provides a Consistent OO API for Data Model Access
- Still Allows for Database-Specific Optimization