sql

This release unblocks mindplay/unbox^3 and psr/log^3.

This release includes a bugfix, which could be a breaking change in certain iteration scenarios - run your tests, and read the commit log if you run into trouble.

The package now requires PHP 7.3 and builds on PHP 8.0.

This release fixes some architectural issues by refactoring to remove some API points that didn't actually work - e.g. query-builder methods that would lead to SQL queries that couldn't actually be executed.

Removal of those API points strictly is a breaking change, but as far as versioning, this release is regarded as a bugfix, since the API points that have been removed never produced working code in the first place.

This is also the first release that includes proper documentation! 🎉

Improved error-handling in Connection::transact() under PHP 7

Adds support for DATE columns via DateType

This release fixes a minor issue with SQL formatting in error-messages.

Add extension requirements to composer.json

This release adds support for schema-segregation in Postgres - as well as emulation under MySQL by prefixing table-names.

This leads to a number of BREAKING CHANGES which are mostly internal and should be zero or very little work to address to client code:

The Driver interface has a new method - if you implemented your own driver, you will need to implement the new method. (Included Postgres and MySQL drivers have been upgraded.)

The Table constructor signature has changed - a new dependency was introduced. If you override the constructor signature in your Table extensions, you will need to add the missing argument - the DI container will take care of the rest.

Likewise, the TableFactory interface has changed - if you implement your own TableFactory extension, you will need to add the new argument.

Minor patch, may address an issue with timestamps on systems with certain timezone settings.

Major release with some breaking changes - mainly the upgrade to mindplay/unbox^2.

Improved JSONType

The Connection::fetch() method no longer includes the $mappers argument, as this feature overlapped with the Mappers trait and MapperProvider interface.

Mappers are highly query-specific and completely dependent on the returned data, the order in which mappers are being applied, and so on.

To upgrade, apply your mappers to your query object (map() method) rather than in your call to Connection::fetch().

Minor BC breaks in PDOProvider.

Adds optional PRO providers.

No BC breaks since 0.3.

Another round of architectural improvements.

Still unstable, still needs test-coverage.

Surface API shoud be relatively stable now - internal API still subject to changes.

This is an unstable release - many tests are still missing.