Are you saying using a metabones adapter on Sony mirrorless camera body, then mounting a reverse macro ring on the metabones adapter then attach a lens (in reverse)?
I have not tried before, but sounds do-able, as the reverse macro ring just converts the bayonet mount on the metabones adaptor or camera body to a filter thread for you to screw in your lens. Or consider a straight forward 3rd party extension tube without electric contacts, since you're losing electronic coupling anyway with a reverse ring? (I'm not sure which gives better magnification but it also depends on the focal length of your lens)
Maybe some expert can give their real life experience?