Use specific PDO drivers instead of PDOConnection

Problem/Motivation

Since PHP 8.4 new specifc driver connection classes been introduced and starting with PHP 8.5 beta3 leads to warnings

Steps to reproduce

Related RFC https://wiki.php.net/rfc/deprecations_php_8_5#deprecate_driver_specific_...

Proposed resolution

Update all shipped code DB drivers to use new specific drivers like the commit

Remaining tasks

- create MR
- review/commit

User interface changes

Introduced terminology

API changes

Data model changes

Release notes snippet