We have run into many query tool filter limitations, and one way around these limitations would be to populate an import selection with the results from dynamic SQL (insert into xxx select ID from table where criteria). The import selection could then be used in query filters. Would also need the ability to schedule these processes to refresh the static import selection.