Edit History

I didn't fix it but I've done a workaround. It consists in overriding validation method and bypass it's validations. Of course I develop my queries in mysql before I paste on Prestashop.

So I created a new file: /override/controllers/AdminRequestSqlController.php with the following content:

<?php

class AdminRequestSqlController extends AdminRequestSqlControllerCore
{
    public function _childValidation() {
        if (Tools::getValue('submitAdd' . $this->table) && $sql = Tools::getValue('sql')) {
            $request_sql = new RequestSql();
            $parser = $request_sql->parsingSql($sql);
            $validate = $request_sql->validateParser($parser, false, $sql);
        }
    }
}

?>

After that remove file /shop/var/cache/prod/class_index.php

Hope it helps