Is join (in the sql sense) on columns with different names supported?

[undercover87]

Hello,

I went over the documentation and I think that this https://mikefarah.gitbook.io/yq/operators/multiply-merge#merge-arrays-of-objects-together-matching-on-a-key
actually implements a "JOIN" operation IF the columns we're joining onto from the two tables have the same name.
What if the two columns have different names?
Granted, I could rename one of them to match the other and apply the aforementioned solution but I was wondering if there already exists a way of doing this.