How can you link a SQL file and a Python program?

Question

How can you open, edit, and view a table via SQL in Python, for example, the inteaction with the user happens in Python, like adding values, and you transfer that data from Python to SQL, or opening the table via Python?

Answer 1

import sqlite3

database = sqlite3.connect("example.db")
db = database.cursor()

db.execute("CREATE TABLE table (col1 TEXT, col2 TEXT)")
db.execute("INSERT INTO table VALUES ('hello', 'world')")
database.commit()

print(db.execute("SELECT * FROM table").fetchall())

Answer 2

Take a look at the SQLAlchemy module ☺️

Answer 3

There's mysql connector libraries for python