For that error (thank you for sending!), it seems like multiple queries would be best.
https://cloud.google.com/bigquery/docs/troubleshoot-queries#not_enough_resources_for_query_planning_-_too_many_subqueries_or_query_is_too_complex
Would something like this help?
http://community.retool.com/t/how-to-run-a-large-array-of-queries-in-smaller-batches/3170