support (INTERSECT | UNION | EXCEPT | SETMINUS) clause

[wu121zun]

please support (INTERSECT | UNION | EXCEPT | SETMINUS) clause

[lwba21190]

Doesn't support the use of union in subquery?

[albin3]

Todo: correct subquery grammar follow https://dev.mysql.com/doc/refman/8.0/en/subqueries.html