class_docstr: Hubspot Deals table.
docstr: Updates data from HubSpot "PATCH /crm/v3/objects/deals/batch/update" API endpoint.
  
  Parameters
  ----------
  query : ast.Update
     Given SQL UPDATE query
  
  Returns
  -------
  None
  
  Raises
  ------
  ValueError
      If the query contains an unsupported condition
code: def update(self, query: ast.Update) -> None:
      """
      Updates data from HubSpot "PATCH /crm/v3/objects/deals/batch/update" API endpoint.
  
      Parameters
      ----------
      query : ast.Update
         Given SQL UPDATE query
  
      Returns
      -------
      None
  
      Raises
      ------
      ValueError
          If the query contains an unsupported condition
      """
      update_statement_parser = UPDATEQueryParser(query)
      (
          values_to_update,
          where_conditions,
      ) = update_statement_parser.parse_query()
  
      deals_df = pd.json_normalize(self.get_deals())
      update_query_executor = UPDATEQueryExecutor(
          deals_df, where_conditions
      )
  
      deals_df = update_query_executor.execute_query()
      deal_ids = deals_df["id"].tolist()
      self.update_deals(deal_ids, values_to_update)
  
imports: import pandas
  from hubspot.crm.objects import SimplePublicObjectId, SimplePublicObjectBatchInput, SimplePublicObjectInputForCreate, BatchInputSimplePublicObjectId, BatchInputSimplePublicObjectBatchInput, BatchInputSimplePublicObjectInputForCreate
  from mindsdb_sql.parser import ast
  from mindsdb.integrations.handlers.utilities.query_utilities import INSERTQueryParser, SELECTQueryParser, UPDATEQueryParser, DELETEQueryParser, SELECTQueryExecutor, UPDATEQueryExecutor, DELETEQueryExecutor
  from mindsdb.integrations.libs.api_handler import APITable
  from mindsdb.utilities import log
label_desc: Use image node_id 3 for calling the DealsTable obj's underlying member method code with example usage: obj.update(query) without return types