Select

---
 page_q = session.query(model.Page).all()

 for page in page_q:
     print page.title

—

Session.query(Summit).limit(10)

—

page = session.query(model.Page).first()
print page.title

—

page_q = session.query(model.page)

page_q[2:5]

equal to =>

SELECT page.id AS page_id, page.content AS page_content, page.posted AS page_posted, page.title AS page_title, page.heading AS page_heading
FROM page
LIMIT 3 OFFSET 2

—

page_q.get(1)

—

page = session.query(model.Page).get(1)

—

titles1 = [page.title for page in page_q.filter(model.Page.id==1)]

—

titles2 = [page.title for page in page_q.filter_by(id=1)]

—

filtered_page_q = page_q.filter(model.page_table.c.title.like(u'%page%'))
page = filtered_page_q.first()

—

from sqlalchemy.sql import and_, or_, func, not_

page = page_q.filter( and_(model.Page.title.like(u'%page%'), model.page_table.c.id==1)).first()

SELECT page.id AS page_id, page.content AS page_content, page.posted AS page_posted, page.title AS page_title, page.heading AS page_heading
FROM page
WHERE page.title LIKE ? AND page.id = ?
LIMIT 1 OFFSET 0

—

http://pylonsbook.com/en/1.1/introducing-the-model-and-sqlalchemy.html#queries