def METHOD_NAME(self, query: str) -> Response:
    """
    Receive SQL query and runs it
    :param query: The SQL query to run in MySQL
    :return: returns the records from the current recordset
    """
    session = self.connect()
    try:
        resp = session.execute(query).all()
        resp = self.prepare_response(resp)
        if resp:
            response = Response(
                RESPONSE_TYPE.TABLE,
                pd.DataFrame(
                    resp
                )
            )
        else:
            response = Response(RESPONSE_TYPE.OK)
    except Exception as e:
        log.logger.error(f'Error running query: {query} on {self.connection_args["keyspace"]}!')
        response = Response(
            RESPONSE_TYPE.ERROR,
            error_message=str(e)
        )
    return response