Adding new methods to SnowflakeSqlApiHook: wait_for_query and get_result_from_successful_sql_api_query.

We already have some methods that log api response with rows, but none that actually return rows. Also, there is no method on hook that will poll for query status and wait for success, as the queries are run async via the API.

With these new methods, this is the flow to run query and get the results:

query_id = hook.execute_query(sql=sql, statement_count=0)[0]
hook.wait_for_query(query_id=query_id)
result = hook.get_result_from_successful_sql_api_query(query_id=query_id)

I have another PR that will use these methods, but decided to split it into two for clarity.

^ Add meaningful description above
Read the Pull Request Guidelines for more information.
In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
In case of a new dependency, check compliance with the ASF 3rd Party License Policy.
In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in airflow-core/newsfragments.