class_docstr: This handler handles connection and execution of the Scylla statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","Scylla","statements","."]
docstr: Retrieve the data from the SQL statement.
docstr_tok: ["Retrieve","the","data","from","the","SQL","statement","."]
code: def query(self, query: ASTNode) -> Response:
      """
      Retrieve the data from the SQL statement.
      """
  
      # remove table alias because Cassandra Query Language doesn't support it
      if isinstance(query, ast.Select):
          if (
              isinstance(query.from_table, ast.Identifier)
              and query.from_table.alias is not None
          ):
              query.from_table.alias = None
  
          # remove table name from fields
          table_name = query.from_table.parts[-1]
  
          for target in query.targets:
              if isinstance(target, ast.Identifier):
                  if target.parts[0] == table_name:
                      target.parts.pop(0)
  
      renderer = SqlalchemyRender("mysql")
      query_str = renderer.get_string(query, with_failback=True)
      return self.native_query(query_str)
  
imports: import os
  import tempfile
  from collections import OrderedDict
  import pandas
  import requests
  from cassandra.cluster import Cluster
  from cassandra.auth import PlainTextAuthProvider
  from cassandra.util import Date
  from mindsdb_sql import parse_sql
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb_sql.parser import ast
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.utilities import log
label_desc: Use image node_id 7 for calling the ScyllaHandler obj's underlying member method code with example usage: obj.query(query) and returns: self