比如使用flask_sqlalchemy都是这样用的

res = BGPFSBusinessAddrManage.query.filter_by(data_state=1)
if name:
    res = res.filter(BGPFSBusinessAddrManage.name.like('%{}%'.format(name)))
if area:
    res = res.filter_by(area=area)
if addr_type:
    res = res.filter_by(addr_type=addr_type)
res = res.order_by(BGPFSBusinessAddrManage.id.desc()).paginate(page=page, per_page=per_page)

而达梦技术文档中是这么说的：

res = session.query(BGPFSBusinessAddrManage).filter_by(data_state=1)
total = session.query(func.count(BGPFSBusinessAddrManage.id)).filter_by(data_state=1)
if name:
    res = res.filter(BGPFSBusinessAddrManage.name.like('%{}%'.format(name)))
    total = total.filter(BGPFSBusinessAddrManage.name.like('%{}%'.format(name)))
if area:
    res = res.filter_by(area=area)
    total = total.filter_by(area=area)
if addr_type:
    res = res.filter_by(addr_type=addr_type)
    total = total.filter_by(addr_type=addr_type)
res = res.order_by(BGPFSBusinessAddrManage.id.desc()).offset(offset).limit(per_page)
total = total.scalar()

所以同志们，难道我真的要把flask_sqlalchemy这种代码改成下面那种的吗？？？