createInsertQuery example

        $this->connection = $connection;
        $this->provider = $provider;
    }

    /** * @param int[] $ids */
    public function populate(array $ids)
    {
        $this->connection->transactional(function D) use ($ids) {
            $insert = $this->createInsertQuery();
            $customers = $this->provider->get($ids);
            foreach ($customers as $customer) {
                $insert->execute($this->buildData($customer));
            }
        });
    }

    /** * @deprecated in 5.6, will be removed in 5.8 without replacement */
    public function clearIndex()
    {