我已经分析了Symfony是如何添加其中间件的，并编译了以下代码，可以对查询执行任何需要的操作：
首先按照this doc中的说明创建基本中间件

namespace App\Doctrine;

use Doctrine\DBAL\Driver as DriverInterface;
use Doctrine\DBAL\Driver\Middleware as MiddlewareInterface;

class Middleware implements MiddlewareInterface
{
    public function __construct(
        /* ...dependencies from Symfony DI */
    ) {
    }

    public function wrap(DriverInterface $driver): Driver
    {
        // \App\Doctrine\Driver
        return new Driver($driver, /* ...dependencies */);
    }
}

然后添加额外的中间件：

namespace App\Doctrine;

use Doctrine\DBAL\Driver as DriverInterface;
use Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware;

final class Driver extends AbstractDriverMiddleware
{
    public function __construct(
        DriverInterface $driver,
        /* ...dependencies */
    ) {
        parent::__construct($driver);
    }

    public function connect(array $params): Connection
    {
        // \App\Doctrine\Connection
        return new Connection(parent::connect($params), /* ...dependencies */);
    }
}

namespace App\Doctrine;

use App\Log\Formatter\DatabaseFormatter;
use Doctrine\DBAL\Driver\Connection as ConnectionInterface;
use Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware;
use Doctrine\DBAL\Driver\Result;
use Doctrine\DBAL\Driver\Statement as StatementInterface;

class Connection extends AbstractConnectionMiddleware
{
    public function __construct(
        ConnectionInterface $connection,
    ) {
        parent::__construct($connection);
    }

    public function prepare(string $sql): StatementInterface
    {
        // \App\Doctrine\Driver
        return new Statement(parent::prepare($sql), $sql);
    }

    /*
     * Overwrite any method from parent class with features
     */
}

namespace App\Doctrine;

use Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware;
use Doctrine\DBAL\Driver\Statement as StatementInterface;

final class Statement extends AbstractStatementMiddleware
{
    private array $params = [];
    private array $types = [];

    public function __construct(
        StatementInterface $statement,
        private string $sql,
    ) {
        parent::__construct($statement);
    }

    /*
     * Overwrite any method from parent class with features.
     */
}

Connection类在进行直接请求时使用，Statement在进行准备语句时使用。