In this section, you will learn about the CRUD functionality of the SQLiteOpenHelper and SQLiteCursor classes.

The Sqlite.py file contains several very specific queries:         select_Query = "select sqlite_version()"        delete_query = "DELETE from Database where id = "+str(id)        sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value)        insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)"""        sqlite_select_query = """SELECT * from Database"""        table_query = '''CREATE TABLE Database (                                id INTEGER PRIMARY KEY,                                name TEXT NOT NULL,                                photo text NOT NULL UNIQUE,                                html text NOT NULL UNIQUE)'''                                Write a QueryBuilder function.  The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table).  The QueryBuilder parameters require:  The type of Query, the input tuple data and then constructs a query string based on the parameters.…

Provide an overview of the SQLiteOpenHelper and SQLiteCursor classes, as well as how they are utilized in CRUD operations.

Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.