sample.ts

[].map(itm=> ({...itm, column: itm.column.replace('msaRecord.', '').replace('msaData.','d_').replace('.', '_')}))
 const data =[];

let key = 'CREATE TABLE TABLE (', val = 'VALUES(';
data.forEach(itm=>{
  switch(itm.type){
    case 'string':
    key += `${itm.column.toLocaleUpperCase()} VARCHAR(${itm.width}),`;
    break;
     case 'int':
    key += `${itm.column.toLocaleUpperCase()} INT,`;
    break;
    default:
    break;
  }
  val +=':'+itm.column+',';
})

console.log(key+')'+val+')')