François S. I have worked on the exact use case example you describe successfully with Ontop. Linking entities across databases of different paradigms (relational, NoSQL). Then the RDF ones can simply integrate via SPARQL Federation. The only exception then is LPG, as I have not come across that use case, so am not sure how one would bring that into the fold seamlessly.
I did come across some limitations wrt full SPARQL 1.1 support, but in general thanks to Benjamin C. and team the support on the Ontop (Google Group) forum has been fantastic. This support is one key criterion for consideration. Otherwise, I don't believe there is any other tool or combination of tools that enables this kind of virtualization with such ease.