Related to this question (sort of): Thunderwave in constricted area
Say you found a 1 ft. × 1ft. × 8 ft. hole in a cave that led to the outside, and you loaded a projectile of sorts – let's say a large rock, smaller than the diameter of the hole. If you then cast thunderwave inside of the hole, would the sound and pressure move the projectile out of the hole in a fast manner? If so, what would be the distance someone could use for the cannon?
A 5e Trebuchet has a 600/900 ft. range, so 1/3rd of that for the cannon as it's improvised – and I would say half the damage, so like... 3d8 damage? Obviously, it would take a skilled magic user to use mold earth multiple times to aim and move this thing which would put it at a huge disadvantage... But could it be done?
Keep in mind that I'm looking to see if this could be feasible, not practical or balanced. I don't see anything that says it can't be done, but not anything that says it could be either. The Rule 0 answer always works; however, this is not what I'm looking for.