in reply to Pushing a 'hash slice' to an AoH

Your last example is equivalent to
@{$events[$ctr++]}{'col1','col2','col3'} = @{$sqldata->[$i]}{'col1','c +ol2','col3'};
if you're inclined to do things slicewise.

We're not really tightening our belts, it just feels that way because we're getting fatter.