sql 转 sqlalchemy

Question

有条统计数据的sql：以bookid分组然后统计条数，想转成sqlalchemy，请问如何转换

select name,bname,count(bookid) as count from bookborrow_list group by bookid order by count desc limit 5;