We have negotiated a flat rate deal with Google and have access to a higher concurrent query limit than 100, and even then, it is not the right tool for my use case. BigQuery is also far more expensive.

Our users expect responses in the milliseconds. The user experience is seriously degraded when you approach tens of seconds or batch queries.