How do I “reset” the db.session that runs in a Python script that uses a database from a Flask App?

Solution
...
import mysql.connector

def insert_new_records():
    app = create_app()
    with app.app_context():
        cnx = mysql.connector.connect(
            user=app.config['SQL_USERNAME'], 
            password=app.config['SQL_PASSWORD'], 
            port=app.config['SQL_PORT'],
            database=app.config['DATABASE']
        )
        cursor = cnx.cursor()

        insert_stmt = (
          "INSERT INTO table (id, new_column) "
          "VALUES (%s, %s)"
        )

        # Insert new rows
        id = 1
        new_column = "test" # Could be any Python datatype
        data = (id, new_column)
        cursor.execute(insert_stmt, data)
        cnx.commit()