Yup.
If you embark in a freezing climate, like on a glacier or tundra, you can use this for a cryo-trap.
The water rises from below due to water pressure, and as soon as it reaches above ground it freezes solid, instagibbing everything trapped within the ice.
Once everything is dead send in your miners to dig out the ice and then collect the goblinite.
You can use pumps on either side of a corridor, though you're limited to having a 2 tile wide corridor if you do that approach, and you are vulnerable to building destroyers. They can just smash your pumps.
You could also use stairs. On the level open to the sky and the freezing weather, all of the ground will be down stairs.
On the level below will be water, subterranean so it will not freeze, and up stairs.
To trigger the trap open up the floodgates from your reservoir to use water pressure to force the water up from the lower, liquid level to the open, freezing level. As soon as even 1/7 water hits the cold air it will freeze solid, killing everything within that tile.
Cleanup is easy. The ice will stop further water from flowing, meaning that the trap would actually use very tiny amounts of water each time its triggered. Just close the floodgates to remove the water pressure and dig out the ice.