Pb with parenthesis about sqlsb HOT 3 OPEN

I'll see what I can do, but the syntax is the one of Sqlite, so if the underlying library does not support parentheses, there is little I can do.
Note that it is ok to just write it without parentheses since UNION is non ambiguous here:

SELECT Titre FROM Film
UNION
SELECT Titre FROM Film

from sqlsb.

yes for this example.
Maybe this could help you https://stackoverflow.com/questions/63755888/adding-parenthesis-around-select-expression-gives-an-exception-in-sqlite

from sqlsb.

So after checking the standard, sqlite is right and parenthesis are not needed in union.
What example did you have in mind ? Note that you are not allowed to put ORDER BY clauses below union for instance (and they are useless).

from sqlsb.