Equivalent of "=Query(ImportRange(" in Google Apps Script? -

Equivalent of "=Query(ImportRange(" in Google Apps Script? -

for illustration in new google sheet have these formulas :

=query(importrange("ehd54...dfdfg", "'sheet1'!a:c"),"select * col1 = 'com' limit 5" ,1)")

=query(importrange("ehd54...dfdfg", "'sheet1'!a:c"),"select * col2 contains 'is_a_name' limit 5")

notes:

i don't want utilize set.formula(query(importrange(...

i have seen can equivalent of importrange here: is possible importrange in google apps script? blocked query.

my importrange sheets have 30,000 rows , less 5 columns.

once you've "imported" data, utilize 2d array library filter it, write results sheet.

google-apps-script google-spreadsheet