from sqlalchemy import create_engine
import os

if os.path.exists("some.db"):
    os.remove("some.db")
engine = create_engine("sqlite:///some.db")
engine.execute("""
    create table employee (
        emp_id integer primary key,
        emp_name varchar
    )
""")
engine.execute("insert into employee (emp_name) values (:emp_name)", emp_name="dilbert")

result = engine.execute("select * from employee")
print(result.fetchall())