Yes, Virginia, that’s automated SQL to MongoDB MapReduce

I have to admit, I’m pretty darn proud of this one. This is a righteous hack. I can now write SQL against MongoDB with ColdFusion. My project today was to take this SQL statement: SELECT “goalType”, SUM(“distancekm”) AS “totalkm”, COUNT(*) AS “workouts”, COUNT(“powerSongAlbum”) AS “songcount”, AVG(“distancekm”) AS “avgkm”, MAX(“distancekm”) AS “maxkm”, MIN(“distancekm”) AS “minkm” FROM […]