Working now in a clouded CA environment, I want to use 'common sql' across a number of portlets and reports to ensure the same consistent logic. For example, the client wants to filter by bespoke attribute A, which has to be added to the NSQL, business requirements change and attribute B is required, which then needs to also added to all portlets and reports to filter for projects which have these attributes set.
In non-clouded environments where I have access to the database, I am able to create database functions to handle most of this logic, which is then used on the portlet queries and reports. This meant the logic was consistent and there was only one location to edit the logic making maintenance a lot easier.
For clouded environments where database access is read-only, is there an alternative to database functions which I can not create/edit in the clouded environment?