How to write SQL to generate Site History Report data in Confirm

Products affected: Confirm®
Product feature: Street Works, Site Register
The Confirm® Engineering Team acknowledged that the Site History Report, when exported, only produces the top line. This is restricted because the mechanism within Confirm used to export the data does not have the capability to loop through the modular reports below the Site detail or, otherwise put, the 'sub-reports'. 

Given this limitation Engineering are happy to provide the equivalent SQL which can be run in Data Sources/bespoke reports in order to gather the information required. We attach this herewith in the document - note the Site (the report's header detail) comes first, followed by the other modules (or sub-reports).

These scripts will work in Oracle or SQL Server, however the date value substitutions shown are in SQL Server format. Substitute, instead, something like this for use in Oracle:

inspection_feature.feature_insp_date >= '07-SEP-05'; 

UPDATED:  April 11, 2018