I absolutely love Looker for this reason. It understands foreign keys so if you model everything as stars it just writes SQL for you. So simple, so powerful.

I absolutely love Looker for this reason. It understands foreign keys so if you model everything as stars it just writes SQL for you. So simple, so powerful. I wish something open source would do this painfully obvious thing.