Array with real PDO constant keys would be better than error prone string keys.

"attributes" => [
    \PDO::ATTR_CASE => \PDO::CASE_LOWER,
    \PDO::MYSQL_ATTR_IGNORE_SPACE => 1,
],

I disagree with that. Going that route with using the constant names for keys would lock out JSON and YAML configuration files from using this part of phinx easily as you would be forced to use magic number keys which to me is way worse than strings. For your example, this would be the equivalent JSON object:

{
    "8": 1,
    "1009": 1
}

Additionally, it would probably mean that phinx would have to hardcode in the list of attributes for specific drivers so that you don't send \PDO::MYSQL_ATTR_IGNORE_SPACE to postgresql driver for example, and the docs say this about avoiding that scenario:

Using driver-specific attributes with another driver may result in unexpected behaviour.

I agree now, I was not familiar enough with how adapter specific attributes are handled.

Looks good.