• support for PHP 8.5
• OciDriver: in case of applyLimit with different offset returns always the same result

• SqlPreprocessor: IN() inserts parameters directly and bypasses binding
• added GroupedSelection::refreshData()
• Reflection: added comment to Column and Table
• Structure: removed unused parameter

• fixed performance issue of ActiveRow #312
• ConnectionPanel: added whole stack trace listing
• ConnectionPanel: fixed source resolution
• ConnectionPanel: table does not exceed the window
• ConnectionPanel: convert templates to Latte-like syntax
• Selection: factory methods moved to Explorer
• SqlPreprocessor: added braces around where conditions
• SqlPreprocessor: fixed bugs in WHERE
• big refactoring of SqlPreprocessor
• deprecated Driver::SupportSubselect
• Selection::fixedAssoc() silently deprecated
• SQLite: column type can be omitted #315

• ResultSet: added fetchList() as alias for fetchFields() & shortcuts
• ResultSet::fetchAssoc() returns associative array by default, added shortcuts
• removed dead code

Main Features

• Ability to create drivers for additional PHP database extensions, not just PDO
• Merging of Connection & Explorer
• Improved control over data type transformation with options convertBoolean, convertDateTime, and convertDecimal

Changes

• Connection::getInsertId() now returns integers
• The options convertBoolean and newDateTime (returns date as Nette\Database\DateTime) are enabled by default
• Removed interfaces IRow and IRowContainer
• Removed methods Connection::getPdo() and getDsn()

• ResultSet, Selection: fetchPairs() accepts callback
• Selection: support for generics
• drivers: improved getting db structure
• Reflection improvements
• normalizeRow(): removed extra float handling #307
• Helpers::detectType() supports 'INT UNSIGNED'
• md5 replaced with xxHash
• removed return type 'never' to allow inheritance #303
• MySQL: supportBooleans renamed to convertBoolean
• PascalCase constants
• MySqlDriver::initialize() removed support for 'utf8' charset before 5.5.3
• Selection: fixed type error on empty aggregations #309
• SqlsrvDriver::applyLimit() removed support for SQL Server < 2012
• support for PHP 8.4

• added reflection for Table, Column, Index, ForeignKey
• returns date-time as immutable Nette\Database\DateTime (when 'newDateTime' is enabled) #270

• requires PHP 8.1
• added PHP 8 typehints, uses PHP 8.1 features
• MySqlDriver: DECIMAL with precision=0 is returned as int (BC break)
• normalizeRow: converts zero-date 0000-00-00 to NULL (BC break)
• normalizeRow: time columns resets date to 0001-01-01 (BC break)
• Numeric/decimal data type is detected as FIELD_DECIMAL
• MySqlDriver: TINYINT(1) is returned as bool (when 'supportBooleans' is enabled)

• support for PHP 8.3
• used PhpStorm Language attribute

• composer: allows nette/utils 4.0