This one's for Rob

gridQuery2.py

#!/usr/bin/env python

import sqlite3

def create_connection(db_file):
    """ create a database connection to the SQLite database
        specified by the db_file
    :param db_file: database file
    :return: Connection object or None
    """
    database = 'Chinook_Sqlite.sqlite' # /config/home-assistant_v2.db
    conn = None
    try:
        conn = sqlite3.connect(database)
    except Exception as e:
        print(e)
        raise

    return conn

def select_all_tasks(conn):
    """
    Query all rows in the tasks table
    :param conn: the Connection object
    :return:
    """
    cur = conn.cursor()
    cur.execute("SELECT Name from Artist where ArtistId = 52;")

    rows = cur.fetchall()

    for row in rows:
        print(row)

c = create_connection(None)
select_all_tasks(c)

@carryonrewardless
Using Chinook_Sqlite.sqlite as input, this outputs:

('Kiss',)

Works! Three extra lines. Some research for me to do on what those changes do in the script. :-)