yiisoft/db

📋 Changes

• Enh #1145, #1148: Explicitly import classes, functions, and constants in "use" section (@mspirkov)
• Enh #1148: Add `declare(strict_types=1)` to `Yiisoft\Db\Constant\ColumnInfoSource` (@mspirkov)
• Enh #1156: Remove unnecessary files from Composer package (@mspirkov)
• Enh #1158: Explicitly mark readonly properties (@vjik)
• Enh #1159: Improve performance of `AbstractSqlParser` class methods (@Tigrov)
• Bug #1127: Fix `AbstractSchema::hasTable()` and `AbstractSchema::hasView()` methods to support names quoted with curly

📋 Changes

• New #1013: Add `StringableStream` class to cast binary column values to `string` using `(string) $value` (@Tigrov)
• New #1015: Add mode parameter to `Like` condition (@vjik)
• New #1020: Support column's collation (@Tigrov)
• New #1024: Add `ColumnName` and `Value` expressions (@vjik)
• New #1029, #1048, #1069: Add functions as expressions (@Tigrov)
• New #1033: Add `All` and `None` conditions (@vjik)
• New #1034: Add `ConnectionInterface::getColumnBuilderClass()` method (@Tigrov)
• New #1040, #1043: Add `DateTimeValue` class (@vjik, @Tigrov)
• + 158 more

📋 Changes

• Enh #778: Deprecate unnecessary argument `$rawSql` of `AbstractCommand::internalExecute()` (@Tigrov)
• Enh #779: Specify result type of `QueryInterface::all()`, `CommandInterface::queryAll()` and
• Enh #779: Specify populate closure type in `BatchQueryResultInterface` (@vjik)
• Enh #781: Skip calling `CommandInterface::getRawSql()` if no `logger` or `profiler` is set (@Tigrov)
• Enh #784: Specify result type of `ConstraintSchemaInterface::getTableIndexes()` method to `IndexConstraint[]` (@vjik)
• Enh #784: Remove unused code in `AbstractSchema::getTableIndexes()` (@vjik)
• Enh #785: Refactor `AbstractCommand::getRawSql()` (@Tigrov)
• Enh #786: Refactor `AbstractSchema::getDataType()` (@Tigrov)
• + 14 more

📋 Changes

• Chg #755: Deprecate `TableSchemaInterface::compositeForeignKey()` (@Tigrov)
• Chg #765: Deprecate `SchemaInterface::TYPE_JSONB` (@Tigrov)
• Enh #746: Enhanced documentation of `batchInsert()` and `update()` methods of `DMLQueryBuilderInterface` interface (@Tigrov)
• Enh #756: Refactor `Quoter` (@Tigrov)
• Enh #770: Move methods from concrete `Command` class to `AbstractPdoCommand` class (@Tigrov)
• Bug #746: Typecast values in `AbstractDMLQueryBuilder::batchInsert()` if column names with table name and brackets (@Tigrov)
• Bug #746, #61: Typecast values in `AbstractDMLQueryBuilder::batchInsert()` if values with string keys (@Tigrov)
• Bug #751: Fix collected debug actions (@xepozz)
• + 3 more

📋 Changes

• New #617: Add debug collector for `yiisoft/yii-debug` (@xepozz)
• Enh #617, #733: Add specific psalm annotation of `$closure` parameter in `ConnectionInterface::transaction()`
• Bug #741: Fix `alterColumn()` method to accept `ColumnInterface::class` in argument `$type` (@terabytesoftw)

📋 Changes

• Chg #722: Remove legacy array syntax for typecast. Use `Param` instead (@terabytesoftw)
• Chg #724: Typecast refactoring (@Tigrov)
• Chg #728: Refactor `AbstractSchema::getColumnPhpType()` (@Tigrov)

📋 Changes

• Initial release.