I have SQL of the form
SELECT a FROM (
SELECT a FROM ds.t1 UNION
SELECT a FROM ds.t2
) t

The execution factory extends JDBCExecutionFactory and supports everything except row offset. It appears that the two unioned SELECTs are being executed as separate statements rather than the entire unioned set being pushed down to the datasource.

Attached is plan