How can we query multiple SharePoint Lists like SQL Query

I have multiple SharePoint list which has data like a STAR schema i want to query them so i can get the result from all the lists. Any thoughts on how we can do that?