Investigate a way for adding dialect like as 'mybatis:where' and 'mybatis:set' tag

In current feature, it does not support for appending and trimming SQL key-word(e.g. WHERE, AND, SET) like as <where> and <set> provided by xml based scripting language.
So, we need to add the no-dynamic phrase (e.g. WHERE 1 = 1, SET id = id, etc ...) before dynamic parts. I think it is easy writing but it is troublesome rule.

I hope to be enabled to write as follow:

SELECT * FROM names
/*[# mybatis:where]*/
  WHERE
  /*[# th:if="${firstName} != null"]*/
    firstName = /*[('#{firstName}')]*/ 'Taro'
  /*[/]*/
  /*[# th:if="${lastName} != null"]*/
    AND lastName = /*[('#{lastName}')]*/ 'Yamada'
  /*[/]*/
/*[/]*/

Start with the issue's MyBatis dynamic SQL reference and the sample mybatis:where syntax. Determine how the proposed dialect should trim or append WHERE, AND, and SET around conditional SQL, then define tests covering the shown firstName and lastName cases and the expected generated SQL.