I occasionally have “questions” that are easiest & fastest to answer by querying the foreman database directly, rather than writing a script to perform and combine the results from dozens or hundreds, or more, API calls. And it tend to prefer to store complicated/large queries in views.
Would it OK to create an additional schema in the database and such views there? Or could the presence of an additional schema next to “public” cause issues ?
(I can think of other ways to perform these SQL queries without having to do this, but would prefer to do it this way, if it’s safe.)