Complex joins and raw sql query problem

I’ve been digging a bit deeper and from the docs and resources online I gather I should be able to map a query result to either a Hanami::Entity or a Dry::Struct. But in either case I always get back only the Segment entity with the above raw sql call.