Update PHPUnit to v12

[DanielBadura]

For this we need these points solved:

• Migrate from annotation like @covers to attributes #[CoversClass] etc. Done in Migrate from PHPUnit phpdoc tags to attributes #732
• Drop PHP 8.2 support
• Wait for prophecy support for PHPUnit 12 (PHPUnit 12 support phpspec/prophecy-phpunit#68). The other solution is to remove the dependency and rely only on the mocking API from phpunit (PR for removal: Remove prophecy, change tests to use phpunit native mocking #738)
• Fix deprecation about addMethods which was removed in PHPUnit 12 (Deprecate MockBuilder::addMethods() sebastianbergmann/phpunit#5320). We are using this method for testing a dedicated method of PDO when using PostgreSQL, pgsqlGetNotify. Ref: Deprecate MockBuilder::addMethods() sebastianbergmann/phpunit#5320 (comment)

Maybe there are other topics which needs to be done, these will be added then to the list.