IMO, i feel this is a design flaw. Without understanding what's a NOSQL used for you can't except joins to work.

Shouldn't there be a checklist to show "What applications can be moved to cloud (appengine here)? including the myths, expectations, assertions?"