import sqlalchemy as sa


metadata = sa.DynamicMetaData()

one_table =  sa.Table('one_table',metadata,
		sa.Column('id', sa.Integer, primary_key=True),
		sa.Column('the_label', sa.String(30), key='label'),
		)
																
e = sa.create_engine("sqlite://")
metadata.connect(e)
one_table.create()

# insert some rows: this uses the declared keys
one_table.insert().execute(id=0,label='oula')
one_table.insert().execute(id=1,label='blabla')
one_table.insert().execute(id=2,label='arf')

# ok now select rows
all_rows = one_table.select().execute().fetchall()
r = all_rows[1]
print "Keys in row: %s" % r.keys()
print "r.the_label: %s" % r.the_label
print "r.label: %s" % r.label	# won' work