So if you are making a photo of a sculpture a foot wide, that is like a head shot in portraiture. Try a lens that you have already. Probably anything will do. Seems to me to be a normal thing to do with a lens designed for 8x10.
If you want to make a picture of something much smaller that that, it will be easier on 4x5 and there are better lenses available. Very small stuff is easiest with a very small format, like 35mm or digital.