HQL now supports update, delete and insert ... select ... statements. See Section 13.4, “DML-style operations” for details.
update
delete
insert ... select ...