After six months running MongoDB's aggregation pipeline across two production deployments, here's an honest comparison of approaches, real performance numbers, and practical code examples covering grouping, array unwinding, joins, and time-based reporting — from basic stages to full Python integration.