通过使用with_entities()方法来获取要在结果中返回的列
- # 查询制定的id列
- result = RiskDataModel.query.with_entities(RiskDataModel.id) # 返回BaseQuery
- # 返回指定的两列
- result = RiskDataModel.query.with_entities(RiskDataModel.id, RiskDataModel.name)
- # 并且去重
- result = RiskDataModel.query.with_entities(RiskDataModel.store_st_id).distinct().all()