Add support for Short query optimized mode in BigQuery

[fredsadaghiani]

Would it be possible to add support for "Short query optimized mode" in BigQuery to the Ruby SDK?

Is your feature request related to a problem? Please describe.
The BigQuery library does not support Short query optimized mode.

Describe the solution you'd like
Add support to the client SDK to perform queries that make use of the Short query optimized mode. With the other SDKs (Python, Javascript, et al), this was done through an env variable.

[CodingAnarchy]

This would be super helpful for us as well. We were excited to try this feature, as it is perfect for our use case, but Ruby hasn't had an update to enable it so all we could do is try it manually and verify that it would help us a lot.

[piam]

Our team would definitely make use of this feature as well. We've seen how it's helped optimize queries in other SDKs, and having it available in Ruby would be a game-changer for us. It would really help streamline our workflow and improve performance. This addition would be hugely valuable to us, and we're excited to see it implemented.