oneiric vs pie-in-the-sky

Resembling a dream; dreamlike. 

Of or pertaining to dreams. 

Of a dream unlikely to ever come true; impractical, unrealizable. 

Lacking reality and serviceability.