Assuming unions in subselects are not possible (which would not surprise me),

My first thought would be to move the union from the subselect to the main
select. In other words, perform several main selects which are unioned
together where each main select uses a single, simplified subselect.

Would that work for your application? (I'm not sure if it would result in
duplicate records in the final result set.)