Can you just have a general policy where every table that has an is_deleted flag also automatically gets a view, and clients must use the view unless they have

Can you just have a general policy where every table that has an is_deleted flag also automatically gets a view, and clients must use the view unless they have a particular need to access deleted data?