one of the draft patches by @kamils-iRonin introduces SQL views via scenic gem. I think it’s a good step forward now when we finally have a single database, but I would like to bring this to attention to the broader group for discussion.
We do have the NullDB database adapter for running migrations/seeds but as long as this status view is not used it should not be any concern.
Which on the other hand means creating a brand new ActiveRecord model which is not ideal. But IIUC this could be just a subclass with overloaded table_name and a new view which costs almost nothing as long as it is not materialized.