Php connector not adding the filter nor the sort

Suite and Optimus Suite 5
#1

I have a connector that in render using render_sql but when i add a union in the sql , it stops filtering and it stops sorting the connector is there any way to fix it . I tested it with like
SELECT *
FROM(
SELECT id, name from table A
union
SELECT id, name from table B) and it stops working

#2

You can’t use filtering / sorting / dynamic loading features of the connector with union in the SQL query.

You can create a materialised view in the database based on your union query and later use normal select from that view in the connector.