Constructing more complex joins

[felipesere]

Given a shoppinglists that can have many ingredients which in turn can have many quantities (e.g. you need to buy 4 apples for a cake but also 6 apples to just eat), I have a query like this gathers all that data up:

        SELECT
          "shoppinglists"."created_at" AS "s_created_at",
          "shoppinglists"."updated_at" AS "s_updated_at",
          "shoppinglists"."id" AS "s_id",
          "shoppinglists"."name" AS "s_name",
          "r1"."created_at" AS "i_created_at",
          "r1"."updated_at" AS "i_updated_at",
          "r1"."id" AS "i_id",
          "r1"."name" AS "i_name",
          "q"."id" AS "q_id",
          "q"."created_at" AS "q_created_at",
          "q"."updated_at" AS "q_updated_at",
          "q"."unit" AS "q_unit",
          "q"."value" AS "q_value",
          "q"."text" AS "q_text"
        FROM
          "shoppinglists"
          JOIN "ingredients_in_shoppinglists" AS "r0" ON "r0"."shoppinglists_id" = "shoppinglists"."id"
          JOIN "ingredients" AS "r1" ON "r0"."ingredients_id" = "r1"."id"
          JOIN "quantities" AS "q" ON "r0"."quantities_id" = "q".id
          ORDER BY
            "shoppinglists"."id" ASC,
            "r1"."id" ASC,
            "q"."id" ASC

I have manually executed the statement and used FromQueryResult with the adequate prefixes to reconstruct my models.
Then I've done a bunch of looping and aggregating to arrive at let result: Vec<(Shoppinglist, Vec<(Ingredient, Vec<Quantity>))>>.

Is there a way to construct such a query through the normal composition functions?
Ideally, I'd be able to finalize it with either .all(..) or .one(..) depending on my needs...