Another possible solution: Multiple databases in one question without a data warehouse- YES YOU CAN!
You could just create views in a linked database. Then there’s no need to change your source database. Nor do you need any special rights on the source.