Pipe dreams are often schemes that just won’t work.
Like daydreams, pipe dreams dissolve like smoke rising into the air, which is appropriate, because the metaphor comes from smoking opium.
The phrase can be traced to print in the late nineteenth century, when it was fashionable for hedonists and the upper classes to escape reality through an opium pipe.
Those “on the pipe” were experiencing opium-induced “pipe dreams.”