def METHOD_NAME(self, _query, encoding='utf-8'):
    cnx = mysql.connector.connect(
        host=self.config["api"]["mysql"]["host"],
        port=self.config["api"]["mysql"]["port"],
        database='mindsdb',
        user=self.config["auth"]["username"],
        password=self.config["auth"]["password"]
    )
    cursor = cnx.cursor(prepared=True)
    for subquery in _query.split(';'):
        # multiple queries in one string
        if subquery.strip() == '':
            continue
        cursor.execute(subquery)
    if cursor.description:
        columns = [i[0] for i in cursor.description]
        data = cursor.fetchall()
        res = Dlist()
        for row in data:
            res.append(dict(zip(columns, row)))
    else:
        res = {}
    return res