How to filter main query using subqueries via JS Client?

E.g, the goal is to fetch profiles that have job experience. Please refer to the attached picture for more details. Is it possible to do this using the JS Client?

The ilike filter here only filters the subquery, not the main query (profiles) if that makes sense?