The session class contains a "createSQLQuery()" method to provide dynamic native sql in runtime. Are there any approaches to execute dynamic native insert/update/delete SQL statement?

Connection c = session.connection();
and straight JDBC code from here

Please consult javadoc for your H version because you may need to close connection yourself.
And do not forget to invalidate appropriate objects in Session or Second level cache...

Can I still use the createSQLQuery() and use the inser/update/delete SQL statement instead of the query statement?

It just cheat the createSQLQuery() method to execute an update for me. Is it possible?

Not yet. But you can use HQL to execute inserts, updates, and deletes in addition to selects.

The <sql-insert> in the mapping file can not meet my requirement because I was asked to use map one POJO to multiple tables of same structure. The table name is dynamic in runtime. e.g. anytime a new device was created, a device_? table is created in the database. the ? is the primary key of the device. Then, all data from this device will be put into this table. So, another question is that can I use Hibernate to create a table at runtime instead of direct JDBC?