IMO, this appears not to be something that solves the SQL learning curve but rather the usability of a query language with tooling.

I don't think there is much that could be done to address left, right, inner, outer join semantics. It's just something you have to learn if you want to do a lot of SQL (though, you are likely only ever going to use left and inner joins).