There might be some value in an "INFER JOIN" keyword that tried to guess what relationship you wanted to use for the join, either based on defined relationships

There might be some value in an "INFER JOIN" keyword that tried to guess what relationship you wanted to use for the join, either based on defined relationships between the tables or based on statistics about the most common join conditions actually used.