Not sure why anyone thinks you can put water in lungs given the basic spellcasting rules say you have to have an unobstructed path to a target. You don't have an unobstructed path to someone's lungs. 

something people seem to forget often is bard and college of lore...

One of the pc at our table just cast this to produce 45 pounds of meringue through a tunnel as we were being chased by a pack of kobolds in a dungeon at low health. We escaped because the dm ruled that the tunnel became difficult terrain for the them. Spent a bit of time to do some math and research to find out the volume per weight of the meringue  and how much it filled the tunnel to block sight and path. Fun night of rolepplaying, math, and homework. 🤣 Very creative use of this spell. Next time we will try 45pounds of jam to simulate a grease spell. 

Quote from thegerrybear >>

One of the pc at our table just cast this to produce 45 pounds of meringue through a tunnel as we were being chased by a pack of kobolds in a dungeon at low health. We escaped because the dm ruled that the tunnel became difficult terrain for the them. Spent a bit of time to do some math and research to find out the volume per weight of the meringue  and how much it filled the tunnel to block sight and path. Fun night of rolepplaying, math, and homework. 🤣 Very creative use of this spell. Next time we will try 45pounds of jam to simulate a grease spell. 

That is absolutely delightful, well done.

my players now have a unidentified 9th level scroll of upcasted create food and water.
they do not know this.

I genuinely think that any world based on 5e would be radically different from a classic middle ages inspired fantasy world. This spell is one of the reasons for that.

Thats not the point of 5e though and if you really need a realistic system you'll probably have to play something like Acks 2

Eberron is based on looking at how dnd mechanics would affect society, but it still has agriculture because what a lot of people here miss is that PC’s, even PC-likes are rare, and that differs drastically depending on the class as well. 

wizards and artificers are good because their skills can be taught, at least to some extent. 
according to the rules for 5.5E at least, villages rarely have access to 3rd level spells and people capable of casting 6th level and higher spells almost never settle in towns. 

Eberron is wide magic but not that high, compared to other settings which have magic as higher but less wide. 
so in Eberron common and uncommon magic items are commercially available, as are 1st-3rd level spells, but not through the usage of PC’s or the like. 

most spellcasters in the setting are Magewrights and Adepts for arcane and divine+primal magic respectively, who have no spell slots but do have the ability to cast any spell they know as a ritual at the cost of expending 20GP of components per level of said spell, and IIRC that even applies if it is naturally a ritual. 

Even wizards are less common then you’d think, as the majority of spellcasters able to use magic in a manner comparable to PC’s are instead mages (no connection to the term archmage), who cast spells like wizards but with significant reductions on what spells they can learn, the same way that most IRL scientists specialise in a single field. 

eberron has an effective tech level somewhere akin to 19th or early 20th century Europe as a result, albeit heavily influenced by game mechanics. 

of course, the average dnd player doesn’t actually get the reasons behind this sort of thing, because what a lot of people don’t get is that PC’s are exceptional; martials are to the likes of veterans and knights (themselves elite heavy infantry) what special forces are to regular soldiers IRL, a wizard is to a mage what a genius polymath able to outdo most scientists is to a regular scientist, ect.