@AleksiAlkio looks like he is asking List Ref top to bottom in the reference hierarchy. I tried the example you provided. Do you have any working example ? If this actually works then it would be nice.
This works on 1st level but not on 2nd and 3rd levels
Thank you for the reply @AleksiAlkio But, all these columns are of LIST type so the dot operator is not working since its a list dereference. I am able to dereference the first level i.e. [Related Table2][Related Table3] but when i try [Related Table2][Related Table3][Table3 column], its throwing error
Aaa.. I thought you were meaning the opposite, my mistake. With lists, not possible, unfortunately. Or at least I haven’t found the way to do it directly without SELECT expression