If it was simply perforations, it wouldn't work when the bottle is upright because those perforations would let the air into the top of the straw. Rather, the straw is made of a membrane which lets water through while blocking gas.
I’m not sure you can make a membrane that does that? I get the sense there is a membrane that wicks the fluid around the surface of the tube so you always have to pull in liquid before the gas? Maybe that’s the same thing.
You can retrofit it into an existing spray bottle with some flexible tubing and something to weight down the end, like some stainless-steel nuts. That way, the end of the tube follows gravity along with the liquid and ensure it remains submerged.
I don't think there is any idea here other than retrofitting this innovative straw into existing spray bottles.
You need to let air through or else it creates a vacuum. What's happening is it just slows the flow of air enough to be able to get suction from the fluid. Having fluid in the tube also helps.
You need to let air through into the bottle to replace the volume of ejected water. No air should ideally be entering the straw.