How do you perform a UNION query

Apr 28, 2015 at 9:32 AM
Can anybody suggest the best way to perform UNION/INTERSECT/EXCEPT conjunction queries?

The only way I can see how to do it is to create separate DBSelectQuery object and manually combine their SQL statements, something like:
query1.ToSQLString(db).TrimEnd(';') + " UNION " + query2.ToSQLString(db);
Has anyone made any extensions to the library to support this?