I agree with you that it's a pain writing join conditions with many fields... But I think that's a shortcoming of the client tool, rather than the language. I

I agree with you that it's a pain writing join conditions with many fields... But I think that's a shortcoming of the client tool, rather than the language. If SQL tools auto completed the join conditions as best as they could it would probably be a great help.