from sqlalchemy import func # SYNTAX - func.coalesce(model.prop, default_value) db.session.query( UserModel.id, func.coalesce(UserModel.active, false).label('is_active'), ).filter( UserModel.status == 'active' ).all()
0 Comments