When using spring data I can see batching being done in the generated stats. But all the insert or update queries are
insert into ....
insert into ....
instead of
INSERT INTO table1 (field1, field2) VALUES ("string1", 1), ("string2", 2);
I have used the property spring.datasource.hikari.data-source-properties.rewriteBatchedStatements=true but it's not making any difference. I believe this setting is only for mySQL and PostgreSQL. Is there any SQL server alternative?