Need further info to be sure this is actually a blown motor. I'd first suspect that a simple broken camshaft chain could cause a no compression situation on all cylinders assuming a valve was left in an open position on each one after it broke. Broken cam sprocket or camshaft itself are other alternatives. There's no possible way you have holes in all 3 pistons so I'm much less likely to suspect something down low.
I suppose it could also be a broken crankshaft, or a HUGELY broken head or block, all of which would obviously be much worse. But these scenarios are much less likely I would think.
When you checked compression that tells me the engine is still spinning, which is good. Were all the pistons actually moving up and down? If yes, then you're definitely looking in the right direction at a valvetrain issue....and I'd strongly suspect a broken chain before anything else.
I'm assuming you're not planning to fix this yourself, so really no great benefit in taking it any further on your diagnostic...just take it in. But if you're planning to possibly address these repairs on your own, we'll need more info to help you determine the problem. Wish you the best.
For an 06, whether out of warranty or not, I'd strongly consider taking it in to ask (nicely) for some help from your dealer.