Update to DBAL 4.x.x

[mrbinr]

Symfony FOSUserBundle versions: 4.0.0

Description of the problem including expected versus actual behavior:

I have update my project which use Symfony 6.4 with composer update and DBAL has been updated

...
Upgrading doctrine/dbal (3.9.1 => 4.2.1)
...

Provide logs (if relevant):

Doctrine\DBAL\Types\Exception\UnknownColumnType: Unknown column type "array" requested.
Any Doctrine type that you  use has to be registered with \Doctrine\DBAL\Types\Type::addType(). 
You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). 
If this error occurs during database introspection then you might have forgotten to  register 
all database types for a Doctrine Type.
Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement 
Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache 
or forgot some mapping information.

After investigation the problem seems to be linked to roles property and it cannot being overridden with AttributeOverride.

[iamBunny]

While a change to support this might be coming, i personally doubt it will be changed

For now, your options are:

• Using a custom field type for Array that you can specify in Doctrine config, which i do not recommend
• Migrating from using FosUserBundle (recommended, even suggested by FOS in readme of this bundle) and using Symfony’s native User support that comes with Symfony Security. Migrating will save you headaches in the future.