docstr: Deletes data from the Sharepoint "DELETE /lists" API endpoint.
  
  Parameters
  ----------
  query : ast.Delete
     Given SQL DELETE query
  
  Returns
  -------
  None
  
  Raises
  ------
  ValueError
      If the query contains an unsupported condition
docstr_tok: ["Deletes","data","from","the","Sharepoint","``","DELETE","\/lists","''","API","endpoint",".","Parameters","--","--","--","--","--","query",":","ast.Delete","Given","SQL","DELETE","query","Returns","--","--","--","-","None","Raises","--","--","--","ValueError","If","the","query","contains","an","unsupported","condition"]
code: def delete(self, query: ast.Delete) -> None:
      """
      Deletes data from the Sharepoint "DELETE /lists" API endpoint.
  
      Parameters
      ----------
      query : ast.Delete
         Given SQL DELETE query
  
      Returns
      -------
      None
  
      Raises
      ------
      ValueError
          If the query contains an unsupported condition
      """
      delete_statement_parser = DELETEQueryParser(query)
      where_conditions = delete_statement_parser.parse_query()
  
      lists_df = pd.json_normalize(self.get_lists())
  
      delete_query_executor = DELETEQueryExecutor(
          lists_df, where_conditions
      )
  
      lists_df = delete_query_executor.execute_query()
  
      list_ids = lists_df[["id", "siteId"]].to_dict(orient="records")
      self.delete_lists(list_ids)
  
imports: import pandas
  from typing import Text, List, Dict, Any
  from mindsdb_sql.parser import ast
  from mindsdb.integrations.libs.api_handler import APITable
  from mindsdb.integrations.handlers.utilities.query_utilities.select_query_utilities import SELECTQueryParser, SELECTQueryExecutor
  from mindsdb.integrations.handlers.utilities.query_utilities.delete_query_utilities import DELETEQueryParser, DELETEQueryExecutor
  from mindsdb.integrations.handlers.utilities.query_utilities.update_query_utilities import UPDATEQueryParser, UPDATEQueryExecutor
  from mindsdb.integrations.handlers.utilities.query_utilities import INSERTQueryParser
label_desc: Use image node_id 4 for calling the ListsTable obj's underlying member method code with example usage: obj.delete(query) without return types