Flask的常用查询操作

user1 = User.query.filter(User.username == 'wanwu').all() 
user_list = User.query.filter(User.username.like('z%')).all() # select * from user where username
user_list=User.query.filter(or_(User.username.like('z%'),User.username.contains('i'))).all() #select * from user where username like 'z%' or username like '%i%';
user_list=User.query.filter(and_(User.username.contains('i'),user.rdatetime.gt('2020-10-29')))
user_list=User.query.filter(and_(User.username.contains('i'),User.rdatetime>'2020-10-29'))
user_list=User.query.filter(not_(User.username.contains('i'))).all()
user_list=User.query.filter(Username.phone.in_(['15810106788'],'13801011299')).all()
user_list=User.query.filter(User.username.contains('z')).order_by('').all()