Introduce a view to hide internal relations between tables against client code
Right now, especially in querying hive_posts table, a lot of joins is made at client code during queries executed by API implementations. To simplify it dedicated view shall be created to hide joins and expose all data needed by API implementation.