@Override public String createInitialLoadSqlFor(Node node,TriggerRouter trigger,Table table,TriggerHistory triggerHistory,Channel channel,String overrideSelectSql){
  String sql=super.createInitialLoadSqlFor(node,trigger,table,triggerHistory,channel,overrideSelectSql);
  sql=sql.replace("''","'");
  return sql;
}

@ Override public String createInitialLoadSqlFor ( Node node , TriggerRouter trigger , Table table , TriggerHistory triggerHistory , Channel channel , String overrideSelectSql ) { String sql = super . createInitialLoadSqlFor ( node , trigger , table , triggerHistory , channel , overrideSelectSql ) ; sql = sql . replace ( "''" , "'" ) ; return sql ; }
all the templates have ' escaped because the sql is inserted into a view . when returning the raw sql for use as sql it needs to be un - escaped .
