how to make HQL that will generate SQL to insert multiple values in one statement?

Solution 1:

HQL supports only the INSERT INTO ……… SELECT ……… ; there is no chance to write INSERT INTO ……… VALUES, i mean while writing the insert query, we need to select values from other table, we can’t insert our own values manually. (see documentation and this)