Structure _views functions better

Right now we have a mix of places where our materialized views are located. There is server_status_latest_views.sql at the top level of the repo and then we have a separate directory, views_functions, which is supposed to have all the views related things contained.

There were concerns with tests properly running in our pipeline leading to the current mix (see: !65 (comment 3218022)) but maybe we can create something less mixed up in our repository which might make it easier to not lose track of all the views floating around (a problem noted in #52 (closed)).

@juga added some ideas in !65 (comment 3220985) and !65 (comment 3220989) and I added thoughts in !65 (comment 3218041).