In addition to more liberal control of dependencies when creating functions that do not detect some of the errors of object interdependencies in time but only at startup, and the lack of classic PL/SQL packages such as the Oracle database, rewrite queries when creating Views is one of the most irritating features in the PostgreSQL database. according to my limited 35-year experience in working with databases, there is nothing to justify it.