I couldn't agree with this more. I've just started using TypeORM and the TypeScript aspect is great. However, here I am trying to do a simple distinct left join

I couldn't agree with this more. I've just started using TypeORM and the TypeScript aspect is great. However, here I am trying to do a simple distinct left join, but it's extremely difficult to write because the query APIs consistently get in the way. We're regularly receiving invalid SQL errors, which from a typed language/API seems particularly odd. We're doing this exact same query on the exact same DB in ActiveRecord/Ruby and it's trivial to both write and understand.