Tracing the evolution of dust-obscured activity using sub-millimetre galaxy populations from STUDIES and AS2UDS