order_list = 'id:asc,name:desc,surname:asc'

all_list = db.query(TABLO.id,TABLO.name,TABLO.surname).filter(TABLO.name='asd')

#### Dinamik order_by
 if order_list != '':
    for k in order_list.split(','):
    col = k.split(':')[0]
     sc = k.split(':')[1]
     all_list = all_list.order_by(getattr(TABLO.__table__.c[col], sc)())
 else:
     all_list = all_list.order_by(TABLO.id.asc())
 ##### Dinamik order_by

data = [r._asdict() for r in all_list.offset(skip).limit(limit).all()]

return {'totalcount': all_list.count(), 'datacount': len(data), 'data': data}