Single query returns an object and not an array. Join data transformation expects arrays.
"Undefined property: stdClass::$group_id"
It maybe is not documented that good, but all the data transformations only work on collections/arrays. A workaround would be to just not use single query but use the mutliple records and limit that to 1.
Would it be possible to hide or make it not possible to select single query?