Update!
This morning the shop scoped all cylinders and did compression checks on all as well. The result is that only the one piston (#2) is damaged and as far as they can tell the cylinder walls are OK. All other cylinders have good compression. The final part of the testing is the oil sample that was taken and will be sent out to be analysed. This will tell us if the wear on the engine is normal for the mileage (44,500), if there are any foreign particles such as from a bearing or other component, or perhaps water that shouldn't be there. Apparently this test can be used as a guide to determine when the oil in your engine needs to be changed, rather than the general default of every so many miles or so many months. It could very well be that we don't need to change our oil nearly as often as the manufacturer says.
So if the oil test shows everything to be within normal limits (given that there is a hole in #2 piston), we'll pull the head on that side, drop the pan and change the one piston and rod. I can't wait to see the piston that has caused all the trouble.