So the way I understand it:
In the reverse the lens way - that only works if the lens has manual focus and aperture.
For the Z I have a pair of Wiltrox extension tubes that have connectors for auto focus and F-stop - or switch to manual focus on the lens.
If you use un-powered/plain tubes you need a lens with manual both also.
but - ?
These are what I use: