BigQueryAI LangChain Deprecation Error

[nicolezhang-cryptocom]

Issue

When interacting with bigquery.py using input help, the following error occurs:

LangChainDeprecationWarning: The method `BaseTool.__call__` was deprecated in langchain-core 0.1.47 and will be removed in 1.0. Use :meth:`~invoke` instead.
  print(tools.explain_bigquery_usage())
[ERROR] Failed to initialize agent: BaseTool.__call__() missing 1 required positional argument: 'tool_input'

When interacting with bigquery.py using inputs like limits, cost or info, the following error occurs:

LangChainDeprecationWarning: The method `BaseTool.__call__` was deprecated in langchain-core 0.1.47 and will be removed in 1.0. Use :meth:`~invoke` instead.
  print(tools.get_bigquery_cost_info())
[ERROR] Failed to initialize agent: BaseTool.__call__() missing 1 required positional argument: 'tool_input'

When interacting with bigquery.py using inputs like dataset, data, or tables, the following error occurs:

LangChainDeprecationWarning: The method `BaseTool.__call__` was deprecated in langchain-core 0.1.47 and will be removed in 1.0. Use :meth:`~invoke` instead.
  print(tools.get_bigquery_dataset_info())
[ERROR] Failed to initialize agent: BaseTool.__call__() missing 1 required positional argument: 'tool_input'

Verified Fix

developer-platform-sdk-examples/integrations/bigqueryai/bigquery.py

Line 145 in 393ae23

print(tools.explain_bigquery_usage())

Update to:

print(tools.explain_bigquery_usage.invoke(""))

developer-platform-sdk-examples/integrations/bigqueryai/bigquery.py

Line 149 in 393ae23

print(tools.get_bigquery_cost_info())

Update to:

print(tools.get_bigquery_cost_info.invoke(""))

developer-platform-sdk-examples/integrations/bigqueryai/bigquery.py

Line 153 in 393ae23

print(tools.get_bigquery_dataset_info())

Update to:

print(tools.get_bigquery_dataset_info.invoke(""))

[nicolezhang-cryptocom]

Another improvement worth making (though not really a bug):

developer-platform-sdk-examples/integrations/bigqueryai/bigquery.py

Line 91 in 393ae23

"model": "gpt-4o",

Update gpt-4o to gpt-4o-mini for better compatibility with the free tier and improved accessibility for users.

[leejw51crypto]

i'll work on this issue