Changes in this release:

• Fixes for PHP 8.4 @hrach (#255)

Read the main features overview in a blogpost.

🚀 Notable Features

• Make library PHP 8.1 only (#195)
• Stop decimal/numeric conversion to floats (BC BREAK!) (#206)
• Removed already deprecated code (BC BREAK!) (c8c4367)
• Added PDO drivers (#127)
• Updated new schema API, read-only (36626a8, #199)
• BackedEnum support by @mrceperka (#187)
• Renamed modifier %dts (date-time simple) to %ldt (local date-time) (a25ad7a)
• Implemented support for custom auto-value modified detection (#154)
• Implement Result buffering (#128)
• Switch to nextras/multi-query-parser for SQL parsing (#155)
• Add support for array{schema, table} in %table modifier (#198)
• Add support for Fqn instance in %table and %column (#199, 4f2d3a3)
• Add array spread modifier (#162)
• Add literal-string types for safe SQL construction (#163)
• Add Result::getColumns() (#123)

and many more little features and fixes.

See closed tickets or see full changelog: v4.0.0...v5.0.0

Thank you to all contributors and backers.

• do not add excessive parenthesis to %and / %or processed values
• make ordering of foreign keys detection stable (added order by)

Full Changelog: v5.0.0-rc5...v5.0.0-rc6

What's Changed

• Added QueryBuilder::$distinct option
• Skip Postgres' connection param if the value is empty
• Fix & reimplement getLastInsertedId for various sequence names #240
• Add port to docs by @jakubenglicky #247

Full Changelog: v5.0.0-rc4...v5.0.0-rc5

Changed since 5.0.0-rc3:

• Support PostgreSQL identity columns by @jiripudil in #236
• Fix SQL SRV capitalization of schema table names [d04066f] #237

Full Changelog: v5.0.0-rc3...v5.0.0-rc4

Changes since 5.0.0-rc2:

• Fix repeated QueryBuilder::from() class (#230)
• Build & Test with Postgres 16 (#226)
• Enhanced Tracy panel exception printing (#232)
• Swap Fqn parameter ordering (BC break) (#234)
• Add support for processing Fqn with %column modifier (#234)
• Extend %multiOr, %and & %or support for passing column as Fqn instance (#235)

Full Changelog: v5.0.0-rc2...v5.0.0-rc3

• Build & Test with PHP 8.3 (#222)
• Schema refactoring to readonly classes & Fqn type @hrach (#199)

Full Changelog: v5.0.0-rc1...v5.0.0-rc2

• Library is PHP 8.1 only (BC break!).
• Added PDO drivers for Mysql, Pgsql, Sqlsrv.
• Renamed modifier %dts to %ldt (BC break!).
• Added custom modifier resolution (SqlProcessor::addModifierResolver).
• Added spread variant of modifiers %...s[] that does not enclose formatted list values to (, ).
• New DB reflection API - array migrated to classes, fixed issue with escaping and missing db names.
• PHPStan enhancements & literal-string - typing is better than ever.
• Added support for PHP 8.1 BackedEnum.
• New SQL file importer library nextras/multi-query-parser.

Read more about changes in the blog-post.

Full Changelog: v4.0.5...v5.0.0-rc1

Changes in this release:

• BackedEnum support for i, i[], s, s[] @mrceperka (#187)

🐛 Bug Fixes

• fix debug panel for PHP 8.1 [closes #166] thanks @radimvaculik for reporting

Full Changelog: v4.0.3...v4.0.4