TYPO3 Core

doctrine/dbal already deprecated the combined 'execute()'
method in favour of the streamlined 'executeQuery()' and
'executeStatement()'. These method has been added to the
core facade QueryBuilder with #96247 with proper backport
so extension developer can adopt this and support two core
versions without deprecations or nasty workarounds.

With the raise of doctrine/dbal to ^3.2 the fascade class
uses the concrete methods directly which has not been there
before. Furthermore all core usages has been adopted to the
replacement methods with #96551.

QueryBuilder::executeStatement()

This method is suitable for all INSERT, UPDATE or DELETE
queries build with QueryBuilder. Or to say shortly, these
kind of queries which only returns an integer value stating
the number of the affected rows (number of deleted, updated
or inserted rows).

QueryBuilder::executeQuery()

This method is suitable for all SELECT or COUNT queries, or
to say shortly, these kind of queries returning a resultset.