sqlgen.groovy

import groovy.text.SimpleTemplateEngine

def rawTemplate = '''CREATE OR REPLACE TRIGGER ${owner}.${entityName}_INSERT 
AFTER INSERT
ON ${owner}.${tableName}
WHEN
${ columns.collect( { "    old.$it <> new.$it" } ).join(/\n/) }
BEGIN
END'''

def engine = new SimpleTemplateEngine()
def tpl = engine.createTemplate(rawTemplate)
def output = tpl.make(
	[ owner: 'ismaile', 
	tableName: '4201', 
	entityName: 'SalesOrder',
	columns: ['IBITM', 'IBMCU', 'IBLITM' ]])

println output