The past changes of migrating to Doctrine DBAL 3.x
had some flaws:

* Not all changes from Doctrine DBAL 3.x was applied
* core relies on various invalid interfaces and classes, so the
  return types were wrong (also Tests used the old Statement class)
* No explicit ->execute() and ->iterateAssociative() calls
  and fetchColumn() vs. fetchOne()
* added executeQuery() and executeStatement() to QueryBuilder
  decorator class

This change adapts most places to help in migrating to Doctrine DBAL
3.x for TYPO3 v12, but also avoids some unneeded deprecations for now.

Resolves: #96247
Releases: main, 11.5
Change-Id: I60e99511efc4f9ec6d8d651c63becff028de4cf2
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/72430


Tested-by: core-ci <typo3@b13.com>
Tested-by: Benni Mack <benni@typo3.org>
Reviewed-by: Benni Mack <benni@typo3.org>