Service Studio advanced queries verifying engine needs some improvements.
With more complex queries it fails, generating eSpace warnings for perfect SQL syntax.
A delete statement with an inner join
FROM CUSTOMERS C
INNER JOIN TYPES T ON (T.ID = C.TYPEID)
WHERE T.CODE = 'XPTO'
First it doesn't like the alias. Then, if I replace the alias for the table names it doesn't like the keywords "inner" and "join".
The same happens with the "EXEC" command.