sqlalchemy_demo.py

from sqlalchemy import create_engine
from sqlalchemy import select
from sqlalchemy import MetaData, Table, Column, String, Integer

engine = create_engine("sqlite://")
metadata = MetaData()
user_table = Table('user', metadata,
                    Column('id', Integer, primary_key=True),
                    Column('username', String(50)),
                    Column('fullname', String(50))
                   )
metadata.create_all(engine)

conn = engine.connect()
conn.execute(user_table.insert(), [
    {'username': 'jack', 'fullname': 'Jack Burger'},
    {'username': 'wendy', 'fullname': 'Wendy Weathersmith'}
])

query = select([user_table]).\
                    where(user_table.c.username == 'jack').\
                    where(user_table.c.fullname == 'Jack Burger')


# print 'Query SQL:', compile_query(query)
print 'Results:',conn.execute(query).fetchall()