Pb with parenthesis

[ArnaudBegyn]

Parenthesis are not accepted. So it is not possible to use requests with parenthesis. For instance:
(SELECT Titre
FROM Film
WHERE duree)
UNION
(SELECT Titre
FROM Film
WHERE duree);

[Tchou]

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

[ArnaudBegyn]

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

[Tchou]

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).