Allow usage of KEY expression in a join

Description

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.

Environment

None

Assignee

Unassigned

Reporter

Christian Beikov

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Major
Configure