[Feat] Add BQ Dry run check in Bigquery Toolset

[aaslam17]

Often, in NL2SQL usecase, the SQL agent generated by the agent/tool needs to be validated for syntax, data types, incorrect object names etc.
This needs building a seperate tool for doing the bigquery dry run and validating the query.

Either the user passes the SQL or the SQL generated by the sub-agent/tool can be validated using this in-built tool, saving the effort in writing the tool code, re-usability and making the code compact and clean.

[afleisc]

+1 needs this for many BQ agent usecases.

[itodotimothy6]

+1

[Andres-Ayala1]

+1

[dongyuj1]

dongyuj will take a look for this

[dongyuj1]

I can confirm this feature is already supported:

code is here:

adk-python/src/google/adk/tools/bigquery/query_tool.py

Line 41 in 9014a84

dry_run: bool = False,

[GWeale]

Thank you for looking into this! I will close this issue if this comes back up please reopen!