from sqlalchemy import create_engine
import os
if os.path.exists("web.db"):
	os.remove("web.db")
engi = create_engine("sqlite:///web.db")
engi.execute("""
    create table employee (
        emp_id integer primary key,
        emp_name varchar
    )
""")
engi.execute("""insert into employee(emp_name) values ('dilbert')""")
result = engi.execute("select * from employee")
for row in result:
	print(row)

Ответ:
(1, u'dilbert')