Many applications introduce some kind of status to make it easier to share data.

However, more and more modules in your codebase need to be explicit about these assumptions. Views can eliminate the problematic SQL query. It’s also great way to introduce well-defined entities.

https://bartoszgorka.com/view-as-way-to-eliminate-problematic-queries