The core reason was that I've activated spring.datasource.hikari.auto-commit: false. The DBRider calls RiderRunner -- applies same whether you're using dbrider-spring, dbrider-core, dbrider-junit -- and activates sql commands through preparedstatement.

The thing is that when it comes to insert option, gets jdbc connection, calls preparedstatement and does not call a commit.

It seems like it's delegate commit to hikari, as ​HikariCP sets autoCommit to true for connections returned from the pool by default.

So if you turn auto-commit to false in hikari, dbrider insertion won't applied