use Doctrine\DBAL\Cache\ArrayResult;

 final class SomeClass
 {
     public function create(array $items)
     {
-        $result = new ArrayResult($items);
+        $result = new ArrayResult(array_keys($items[0] ?? []), $items);

         return $result;
     }
 }

 use Doctrine\ORM\EntityRepository;
 use Doctrine\DBAL\Query\Expression\CompositeExpression;

 class SomeRepository extends EntityRepository
 {
     public function getSomething($parts)
     {
         $compositeExpression = CompositeExpression::and('', ...$parts);
-        $compositeExpression->addMultiple($parts);
+        $compositeExpression->with(...$parts);
     }
 }

 use Doctrine\DBAL\Statement;

 class SomeClass
 {
     public function run(Statement $statement, array $params): void
     {
-        $result = $statement->executeQuery($params);
+        foreach ($params as $key => $parameter) {
+            $statement->bindValue(is_int($key) ? $key + 1 : $key, $parameter);
+        }
+
+        $result = $statement->executeQuery();
     }
 }

 class SomeRepository
 {
     public function resetQueryPart(\Doctrine\DBAL\Query\QueryBuilder $queryBuilder)
     {
-        $queryBuilder->resetQueryPart('distinct');
-        $queryBuilder->resetQueryPart('where');
-        $queryBuilder->resetQueryPart('groupBy');
-        $queryBuilder->resetQueryPart('having');
-        $queryBuilder->resetQueryPart('orderBy');
+        $queryBuilder->distinct(false);
+        $queryBuilder->resetWhere();
+        $queryBuilder->resetGroupBy();
+        $queryBuilder->resetHaving();
+        $queryBuilder->resetOrderBy();
     }
 }

 $queryBuilder
     ->select('u.id')
     ->from('user', 'u')
-    ->execute();
+    ->executeQuery();

 use Doctrine\DBAL\Connection;

 class SomeClass
 {
     public function run(Connection $connection)
     {
-        return $connection->fetchAll();
+        return $connection->fetchAllAssociative();
     }
 }

 function query(\Doctrine\DBAL\Query\QueryBuilder $queryBuilder)
 {
-    $query = $queryBuilder->select(['u.id', 'p.id']);
+    $query = $queryBuilder->select('u.id', 'p.id');
 }