This is about allowing to do further joins on a map key like JOIN KEY(m) k and KEY(m).association a. I'm not sure if it makes sense to allow altering the join type of the key since the join type either depends on the parent/collection table join type or is irrelevant if rendered with ANSI SQL parenthesis join syntax, but being able to give the key a different alias is definitely a good idea. |