(
  $parts := [
    {
      "Part_Key": 1,
      "Part_No_Revision": "Screw"
    },
    {
      "Part_Key": 2,
      "Part_No_Revision": "Wall Bracket"
    },
    {
      "Part_Key": 3,
      "Part_No_Revision": "Oak Board"
    },
    {
      "Part_Key": 4,
      "Part_No_Revision": "Floating Shelf"
    }
  ];

  $bomParts := [
    {
      "Part_Key": 4,
      "Component_Part_Key": 1
    },
    {
      "Part_Key": 4,
      "Component_Part_Key": 2
    },
    {
      "Part_Key": 4,
      "Component_Part_Key": 3
    }
  ];

  $innerJoin(
    $parts,
    $bomParts,
    "Part_Key",
    "Part_Key",
    "bomParts",
    {
      "grouped": true
    }
  );
)