class_docstr: This handler handles connection and execution of the Solr SQL statements.
docstr: Receive raw query and act upon it somehow.
  Args:
      query (str): query in native format
  Returns:
      HandlerResponse
docstr_tok: ["Receive","raw","query","and","act","upon","it","somehow",".","Args",":","query","(","str",")",":","query","in","native","format","Returns",":","HandlerResponse"]
code: def native_query(self, query: str) -> Response:
      """
      Receive raw query and act upon it somehow.
      Args:
          query (str): query in native format
      Returns:
          HandlerResponse
      """
  
      need_to_close = self.is_connected is False
  
      connection = self.connect()
  
      try:
          # where is not supported
          selected_bins, aero_ns, aero_set = self.parse_aql_query(query)
          aero_ns = aero_ns.lower()
          aero_set = aero_set.lower()
          scan = connection.scan(aero_ns.lower(), aero_set.lower())
          res = scan.results()
          data_df = pd.DataFrame.from_records([r[2] for r in res])
          if (
              " where " in query
              or " WHERE " in query
              or "*" not in selected_bins
          ):
              new_query = re.sub(
                  r"FROM [\w\.]+", "FROM " + "data_df", query, 1
              )
              new_query = new_query.replace(f"{aero_set}.", "")
              data_df = duckdb.query(new_query).to_df()
  
          response = Response(RESPONSE_TYPE.TABLE, data_df)
      except Exception as e:
          response = Response(RESPONSE_TYPE.ERROR, error_message=str(e))
  
      if need_to_close is True:
          self.disconnect()
  
      return response
  
imports: from typing import Optional
  from collections import OrderedDict
  import pandas
  import aerospike
  import re
  import duckdb
  from mindsdb_sql import parse_sql
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
label_desc: Use image node_id 6 for calling the AerospikeHandler obj's underlying member method code with example usage: obj.native_query(query) and returns: response