The Raw data explorer and Custom report builder both allow you to link data from lots of related datasets. It’s only the pre-built reports which are “fixed” to just the pre-built columns.
We’re working on further report improvements to expand this functionality even further, too. If there are any specific requests, please do let us know, as this sort of information is always useful to help us in building what is best.