Version 2.0.0

• New #236, #349: Implement ColumnInterface classes according to the data type of database table columns
  for type casting performance. Related with yiisoft/db#752 (@Tigrov)
• New #276, #288: Implement ColumnFactory class (@Tigrov)
• New #280, #291: Realize ColumnBuilder class (@Tigrov)
• New #282, #291, #299, #302: Add ColumnDefinitionBuilder class (@Tigrov)
• New #292: Override QueryBuilder::prepareBinary() method (@Tigrov)
• New #301: Add IndexType class (@Tigrov)
• New #303: Support JSON type (@Tigrov)
• New #307: Add parameters $ifExists and $cascade to CommandInterface::dropTable() and
  DDLQueryBuilderInterface::dropTable() methods (@vjik)
• New #311: Add caseSensitive option to like condition (@vjik)
• New #316: Realize Schema::loadResultColumn() method (@Tigrov)
• New #323: Use DateTimeColumn class for datetime column types (@Tigrov)
• New #357, #363: Implement ArrayMergeBuilder, LongestBuilder and ShortestBuilder classes (@Tigrov)
• New #358: Add Connection::getColumnBuilderClass() method (@Tigrov)
• New #382: Add enumeration column type support (@vjik)
• New #387: Add source of column information (@Tigrov)
• Chg #272: Replace call of SchemaInterface::getRawTableName() to QuoterInterface::getRawTableName() (@Tigrov)
• Chg #294: Update QueryBuilder constructor (@Tigrov)
• Chg #306, #385: Change supported PHP versions to 8.1 - 8.5 (@Tigrov, @vjik)
• Chg #310: Remove usage of hasLimit() and hasOffset() methods of DQLQueryBuilder class (@Tigrov)
• Chg #326: Add alias in DQLQueryBuilder::selectExists() method for consistency with other DBMS (@Tigrov)
• Chg #330: Rename insertWithReturningPks() to insertReturningPks() in Command and DMLQueryBuilder classes (@Tigrov)
• Chg #332: Use \InvalidArgumentException instead of Yiisoft\Db\Exception\InvalidArgumentException (@DikoIbragimov)
• Chg #365: Update expression namespaces according to changes in yiisoft/db package (@Tigrov)
• Chg #378: Throw exception on "unsigned" column usage (@vjik)
• Enh #255, #321: Implement and use SqlParser class (@Tigrov)
• Enh #260: Support Traversable values for DMLQueryBuilder::batchInsert() method with empty columns (@Tigrov)
• Enh #268: Rename batchInsert() to insertBatch() in DMLQueryBuilder and change parameters
  from $table, $columns, $rows to $table, $rows, $columns = [] (@Tigrov)
• Enh #275: Refactor PHP type of ColumnSchemaInterface instances (@Tigrov)
• Enh #277: Raise minimum PHP version to ^8.1 with minor refactoring (@Tigrov)
• Enh #279: Separate column type constants (@Tigrov)
• Enh #281: Update according changes in ColumnSchemaInterface (@Tigrov)
• Enh #283, #344: Refactor Dsn class (@Tigrov)
• Enh #286: Use constructor to create columns and initialize properties (@Tigrov)
• Enh #288, #317: Refactor Schema::findColumns() method (@Tigrov)
• Enh #289: Refactor Schema::normalizeDefaultValue() method and move it to ColumnFactory class (@Tigrov)
• Enh #293: Use ColumnDefinitionBuilder to generate table column SQL representation (@Tigrov)
• Enh #296: Remove ColumnInterface (@Tigrov)
• Enh #298: Rename ColumnSchemaInterface to ColumnInterface (@Tigrov)
• Enh #298: Refactor DMLQueryBuilder::prepareInsertValues() method (@Tigrov)
• Enh #299: Add ColumnDefinitionParser class (@Tigrov)
• Enh #299: Convert database types to lower case (@Tigrov)
• Enh #300: Replace DbArrayHelper::getColumn() with array_column() (@Tigrov)
• Enh #306: Minor refactoring (@Tigrov)
• Enh #313, #347: Refactor according changes in db package (@Tigrov)
• Enh #315: Remove getCacheKey() and getCacheTag() methods from Schema class (@Tigrov)
• Enh #318, #320: Use DbArrayHelper::arrange() instead of DbArrayHelper::index() method (@Tigrov)
• Enh #319: Support boolean type (@Tigrov)
• Enh #324: Refactor Command::insertWithReturningPks() method (@Tigrov)
• Enh #325: Refactor DMLQueryBuilder::upsert() method (@Tigrov)
• Enh #327, #343: Refactor constraints (@Tigrov)
• Enh #336: Provide yiisoft/db-implementation virtual package (@vjik)
• Enh #340: Adapt to Param refactoring in yiisoft/db package (@vjik)
• Enh #341, #342, #345: Adapt to conditions refactoring in yiisoft/db package (@vjik)
• Enh #348: Remove TableSchema class and refactor Schema class (@Tigrov)
• Enh #350: Adapt to Like changes in yiisoft/db package (@vjik)
• Enh #352: Support column's collation (@Tigrov)
• Enh #359: Update DMLQueryBuilder::update() method to adapt changes in yiisoft/db (@rustamwin)
• Enh #360: Refactor DMLQueryBuilder::upsert() method (@Tigrov)
• Enh #373: Adapt to DQLQueryBuilderInterface::buildWithQueries() signature changes in yiisoft/db package (@vjik)
• Bug #285: Fix DMLQueryBuilder::insertBatch() method (@Tigrov)
• Bug #305: Explicitly mark nullable parameters (@vjik)
• Bug #383: Fix column definition parsing in cases with parentheses (@vjik)

Full changelog