{{#each columns}} {{#if primaryKey}}{{else}}{{/if}} {{/each}} SELECT {{#each columns}}{{columnName}}{{#unless @last}}, {{/unless}}{{/each}} FROM {{metadata.schema}}.{{tableName}} ORDER BY {{primaryKeyColumn.columnName}} DESC SELECT {{#each columns}}{{columnName}}{{#unless @last}}, {{/unless}}{{/each}} FROM {{metadata.schema}}.{{tableName}} WHERE {{primaryKeyColumn.columnName}} = #{{'{'}}{{primaryKeyProperty}}{{'}'}} INSERT INTO {{metadata.schema}}.{{tableName}} ( {{#each insertColumns}} {{columnName}}{{#unless @last}},{{/unless}} {{/each}} ) VALUES ( {{#each insertColumns}} #{{'{'}}{{propertyName}}{{'}'}}{{#unless @last}},{{/unless}} {{/each}} ) UPDATE {{metadata.schema}}.{{tableName}} SET {{#each updateColumns}} {{columnName}} = #{{'{'}}{{propertyName}}{{'}'}}{{#unless @last}},{{/unless}} {{/each}} WHERE {{primaryKeyColumn.columnName}} = #{{'{'}}{{primaryKeyProperty}}{{'}'}} DELETE FROM {{metadata.schema}}.{{tableName}} WHERE {{primaryKeyColumn.columnName}} = #{{'{'}}{{primaryKeyProperty}}{{'}'}}