public function setSql($sql)
    {
        if ('' !== $prefix = $this->db->getPrefix()) {
            $sql = preg_replace('#{{(.*?)}}#', $prefix . '\1', $sql);
        }
        $this->sql = $sql;

        return $this;
    }