Well, the Query(ImportRange()) combination
won’t be the magic solution but help to simplify results and reduce the columns quantity due to Query() function is able to work directly with columns needed by you and filter data dynamically (like a SQL statement).
Years ago I tested this scenario with a GS with 150k rows and had “good results” but it was another time and an experimental test, not an APP in production.