Fired at the muzzle, a representative .45 ACP load (14.9 g, FMJ, 260 m/s) reaches roughly 171 mm (6.7 inches) into packed sand. That is enough to defeat a typical barrier of this material — treat anything behind it as exposed.
Packed sand (~150 mm), e.g. a single sandbag.