The reason those tools have more limited support for joins is mainly because they are making intentional trade offs in favor of other features, eg performance i

The reason those tools have more limited support for joins is mainly because they are making intentional trade offs in favor of other features, eg performance in a particular domain.