MyBatis support more statement in SQL Builder

Feature request

Currently the SQL builder in MyBatis only support INSERT, UPDATE, SELECT, DELETE. However, sometimes we want custom INSERT statement, such as INSERT IGNORE, INSERT ON DUPLICATE UPDATE:

// build a INSERT INTO statement
var sql = new SQL().INSERT_INTO("sbtest");
sql.INTO_COLUMNS("id","name");
sql.INTO_VALUES("?","?");
var sqlStr = sql.toString().replaceFirst("INSERT", "INSERT IGNORE");

Is there any plan to support this?

Comment From: Oliverwqcwrw

I think dynamic SQL can solve your problem right now

Comment From: harawata

As @Oliverwqcwrw , please use https://github.com/mybatis/mybatis-dynamic-sql Improving the built-in SQL builder is not our focus.