Is there a way to use the “get rows node” to return results based on an array?
like the SQL statement “select,from …where fieldX in (‘A’,‘B’,‘C’)”
So, currently the only way to do this is to chain $eq and $or operations for each element in your array.
You could do this buy building an advanced query using the Function Node:
In the Function Node, you can loop through the array and build your advanced query to be used in the Table: Get Rows Node.
But, I will make a feature ticket for you for this 