I have done some experiments with "Beercan" lenses on my Z6, just had to try.
The beer can diameter fits snugly onto the camera lens mouth.
Hope you will go experimenting, I have seen some pinhole photos around on NG.
First picture the setup
Second is first test, next one where I tried to make the hole better.
Hole punched with a needle. The length is 11,5cm, so sort of short telephoto.
The picture quality is not as I would like it, the Nikker S series doet better