doctrine/dbal
Dbal
This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa.
The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between different schema versions. It also supports a middleware-based execution pipeline, allowing the interception of database operations for logging or profiling.
The system covers a broad range of database capabilities, including portable SQL generation for various dialects, transaction management with support for savepoints and isolation levels, and security primitives such as prepared statements and parameter binding to prevent SQL injection. It also provides utilities for result set normalization and CRUD operation helpers.
The project includes a command-line interface for executing raw SQL statements directly against database connections.
Features
- Database Abstraction Layers - Provides a consistent object-oriented interface for interacting with multiple relational database systems via a unified abstraction layer.
- Fluent Query Construction - Provides a fluent query builder for programmatically constructing portable SQL statements using method chaining.
- Schema and Migration Tools - Analyzes differences between two schema representations and generates the SQL required to migrate between them.
- Bidirectional Type Mappers - Includes a type mapper for converting database-specific data types into native application types and vice versa.
- Connection Establishment - Establishes authenticated sessions with relational databases using configuration parameters or connection strings.
- Data Type Mappings - Converts data types between a relational database and the application using built-in and user-defined mappings.
- Database Driver Abstractions - Implements a driver wrapper that standardizes connections and result sets across various relational database vendors.
- Database Drivers - Implements custom adapters and middleware to connect applications to proprietary or specialized relational database APIs.
- Database Object Abstractions - Represents tables, columns, and indexes as structured objects to ensure consistent normalization and quoting.
- Database Agnostic Generators - Provides a mechanism to generate SQL that is compatible across different database vendors and versions.
- Schema Introspection - Retrieves detailed metadata about tables, columns, and indexes to create an in-memory representation of the schema.
- Database Schema Managers - Programmatically inspects, models, and modifies database structures like tables and indexes using an object-oriented approach.
- Database Transaction Management - Controls groups of database operations as single units of work with support for savepoints and isolation levels.
- Object Oriented Querying - Offers a consistent object-oriented interface to interact with multiple relational database vendors.
- Prepared Statements - Implements prepared statements using placeholders to ensure security against injection and enable statement reuse.
- SQL Placeholder Bindings - Uses positional and named placeholders to separate SQL logic from input data and prevent injection attacks.
- Relational Database Abstractions - Provides a consistent object-oriented interface to interact with multiple relational database systems regardless of vendor.
- Programmatic Schema Forge Tools - Provides a programmatic API to execute DDL statements and control database structure without writing raw SQL.
- SQL Dialect Adapters - Adapts queries to ensure compatibility and feature support across different relational database platforms.
- Dialect-Specific SQL Generation - Translates abstract query requests into dialect-specific SQL strings based on the connected database version.
- SQL Query Builders - Ships a fluent query builder for programmatically constructing portable SQL statements across different dialects.
- Portable SQL Generation - Creates database-specific queries and schema definitions that work across different relational database engines and versions.
- Database Wrappers - Implements a driver wrapper that standardizes connections and result sets across different relational database vendors.
- Format Conversions - Translates application objects into the specific string formats required by the underlying database platform.
- Type Mapping - Provides a system for translating database-specific data types into native application types and vice versa.
- SQL Injection Prevention - Implements security primitives using prepared statements and parameter binding to prevent SQL injection attacks.
- Database Type Converters - Translates database-specific data types into native language types to ensure consistent data handling.
- Schema Modeling Objects - Creates an object-oriented representation of tables, sequences, and indexes to generate platform-specific SQL.
- Common Table Expressions - Supports the creation of named temporary result sets using Common Table Expressions (CTEs) within queries.
- Savepoints - Emulates nested transactions by managing SQL savepoints to allow partial rollbacks within a single connection.
- Application Type Mappings - Enables implementing custom conversion logic between application objects and database values via an extensible type system.
- Database Type Mappings - Allows overriding default vendor type mappings to control how database columns are interpreted by the application.
- Nested Transactions - Emulates nested transactions using SQL savepoints to allow partial rollbacks within a single connection.
- Retriable Transactions - Identifies transient failures like deadlocks to trigger automatic retry logic for transactions.
- Autoincrement Implementations - Creates self-incrementing primary keys using identity columns to ensure consistent ID generation across platforms.
- Indexes and Constraints - Creates and manages indexes and foreign key constraints across different database platforms.
- In-Memory Schema Representations - Represents database structures as an object graph to calculate differences and generate migration SQL.
- Query Expression Builders - Includes a dedicated expression builder for generating nested logic and comparison snippets for SQL filters.
- Query Result Fetching - Allows retrieving query results as associative arrays, numeric arrays, or indexed key-value pairs.
- Array Placeholder Expansion - Rewrites SQL queries to flatten arrays into placeholder lists for use in IN expressions.
- Portable Snippets - Generates vendor-specific SQL snippets and function calls to ensure consistent execution across different engines.
- SQL CRUD Operations - Provides simplified CRUD operation helpers to insert, update, or delete rows using associative arrays.
- SQL Literal Escaping - Quotes and escapes string values to ensure they are treated as literals within database statements.
- Transaction Demarcation & Isolation - Provides manual transaction demarcation and the ability to configure isolation levels for units of work.
- Middleware Pipelines - Includes a middleware-based execution pipeline for intercepting database operations for logging and profiling.
- Database Operation Interceptors - Features a middleware-based execution pipeline to intercept database operations for logging and profiling.
