Sony-E lenses have a 18mm back focal length, whereas Nikon lenses have 46.5mm, so there is a lack of
46.5mm - 18mm = 28.5mm to bridge. That means it is like bringing a Sony-E mount lens forward by using
a 28.5mm extension ring on a Sony-E mount camera, when using it on a Nikon camera. So even at infinity
setting, this means using that Sony-E mount lens on a Nikon is working at a very serious macro distance,
if that "adapter" would have zero optical length!
Doable of course, by cobbling some adapters together, which will actually increase this mentioned distance
even significantly more, so if that would be useful then, I have serious doubts...
One will end up with a lens that even at its infinity setting will start to work from some guessed magnification
of 2..3x onwards, that means an object size of about 6..12mm height will completely fill the frame. Ants will
be about the largest one could photograph with such a setting....nothing larger.
When I'm in the mood later, I may want to do the math... :-)