How to query from SharePoint list like SQL

I have multiple SharePoint lists structured like a STAR schema, and I want to query them to retrieve consolidated results from all the lists. Do you have any suggestions on how to achieve this?