We're excited to announce Yii Database 2.0, a major release modernizing the database abstraction layer with PHP 8.1+ features, enhanced type safety, and powerful new capabilities. The drivers have been released as well: PostgreSQL, MySQL/MariaDB, MSSQL, Oracle and SQLite.

New Features

• Implement ColumnInterface classes according to the data type of database table columns
  for type casting performance
• ConnectionProvider for connection management
• ColumnBuilder for column creation
• CaseX expression for CASE-WHEN-THEN-ELSE statements

Yii Database package was tagged along with its drivers.

Yii Database 1.3

• Deprecate unnecessary argument $rawSql of AbstractCommand::internalExecute()
• Specify result type of QueryInterface::all(), CommandInterface::queryAll() and DbArrayHelper::populate() methods to array[]
• Specify populate closure type in BatchQueryResultInterface
• Skip calling CommandInterface::getRawSql() if no logger or profiler is set

First release of Yii Database and its drivers is done.

It is a framework-agnostic package to work with different types of databases,
such as [MariaDB], [MSSQL], [MySQL], [Oracle], [PostgreSQL], and [SQLite].

Using the package, you can perform common database tasks such as creating, reading, updating, and deleting
records in a database table, as well as executing raw SQL queries.

$rows = (new Query($db))  
    ->select(['id', 'email'])  
    ->from('{{%user}}')  
    ->where(['last_name' => 'Smith'])  
    ->limit(10)  
    ->all();