Feature: #88805 - Add type to \TYPO3\CMS\Core\Database\Query\QueryBuilder::set

See forge#88805

Description

TYPO3\CMS\Core\Database\Query\QueryBuilder::set() accepts as additional fourth parameter a type the query value should be casted to when third parameter ( createNamedParameter) is true. Per default string ( \PDO::PARAM_STR) is used.

Impact

Type safe query parameter setting is now also possible via set().

Example:

$queryBuilder->set($fieldName, $fieldValue, true, \PDO::PARAM_INT);
Copied!

ensures $fieldValue is handled as integer type in the resulting database query.