SNOW-575699: Fix flaky query tag tests

[sfc-gh-yixie]

Please answer these questions before submitting your pull requests. Thanks!

1. What GitHub issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes #SNOW-575699, #574078, #574166, #759410

2. Fill out the following pre-review checklist:

   • [x] I am adding a new automated test(s) to verify correctness of my new code
   • [ ] I am adding new logging messages
   • [ ] I am adding a new telemetry message
   • [ ] I am adding new credentials
   • [ ] I am adding a new dependency

3. Please describe how your code solves the related issue. The Snowflake server side query tag has latency so the client tests are flaky. Instead of retrieving the query's query tag from the server side, we now record what query tags are sent to the server.