@ishkabirk The function is called $lookup in Mongo https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/ https://discourse.metabase.com/t/custom-mongodb-query-in-metabase/15256
$lookup