Drupal provides a standard, vendor-agnostic abstraction layer for accessing database servers.
The Drupal 7 Database API provides a standard, vendor-agnostic abstraction layer for accessing database servers. The API is designed to preserve the syntax and power of SQL as much as possible, but also:
- Support multiple database servers easily
- Allow developers to leverage more complex functionality, such as transactions
- Provide a structured interface for the dynamic construction of queries
- Enforce security checks and other good practices
- Provide modules with a clean interface for intercepting and modifying a site's queries