What kind of spray pattern? How far does it need to spray? Is there a flow volume requirement? Is the liquid water? If not, what is the viscosity and surface tension? What droplet size do you want? The design of your spray nozzle has a huge effect on the pressure needed to spray a certain distance. If you only need to spray a liquid with properties similar to water a distance of 20 feet, and do it with large droplets, then a pump sprayer with a properly designed nozzle will do the job.
I once made a simple nozzle with a 0.040" diameter hole for the end of a garden hose. At about 50 PSI, it would shoot a stream over the roof of the house. It was dangerous. It felt like that small diameter solid stream could puncture my skin, so I destroyed it.
I then made another nozzle. This one had a 0.040" diameter orifice aimed at a plate at about a 15 degree angle. That made a fan spray with impressive range and no danger of puncturing skin. It was a way for my daughter to play with a hose without wasting much water.
Design the nozzle first, then determine what pressure and flow rate you need to get the spray you want.
A pinhole hydraulic leak in a logging machine hit one of my uncles on a finger tip, and injected hydraulic fluid all the up to his elbow. He was lucky, the doctors were able to save his arm and hand, but that arm and hand were permanently partly crippled. Mobil hydraulic systems typically run at about 2,000 PSI. The paper mill had a high pressure water system for high pressure washing of machinery. That system ran at 1000 PSI. The safety training including cutting a wood 2 X 4 (50 by 100 mm) in half with the wash gun, followed by the announcement that any horseplay would result in immediate termination of employment.
Stay away from gunpowder. Smokeless powder regularly burns at 50,000 PSI, black powder at pressures over 5,000 PSI. Run some tests, find what pressure you really need, and think very carefully before designing anything that needs more than 100 PSI.