How to write Union or UNION all in kalix

1

i want to query a table based on different attribute and union all result and send back to view .

wanted to check what is the syntax of using UNION.I searched documentation but not able to find it .