If you want to run a NoSQL layer over a relational DB, check out something like Goatfish:

https://github.com/stochastic-technologies/goatfish

Not production code by any stretch, but an interesting concept, and I'd be more inclined to work on it if more people were using it.