Unfortunately DBIC doesn't seem to support UNION natively either. Looks like I'll have to use Arbitrary_SQL_through_a_custom_ResultSource