The failures are caused by the changes in PHP according to https://wiki.php.net/rfc/notice-for-non-valid-array-container.

When the connection is lost or is closed, subsequent transaction will no longer be nested because they started in a brand new session. Our internal representation of the nesting shold take this into account

Internally, ArrayStatement expects every row to be represented as an array regardless of the fetch mode, however FetchMode::COLUMN produces one value per row.

+ fixes issues in MysqlPlatform::getListTableIndexesSQL() and getListTableColumnsSQL() on MySQL 8.0

Fixes #3336.

fix code style

Adding Windows Authentication compatibility according to http://php.net/manual/en/function.sqlsrv-connect.php
"By default, the connection is attempted using Windows Authentication. To connect using SQL Server Authentication, include "UID" and "PWD" in the connection options array."

The first capturing group of the parser regex was stopping form the moment it would find a `[` character.