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()