Recon script generator

Create("ReconSchemaName","ReconTableName");

SELECT Date("DateColumn"),
Sum("SumColumn"),
Sum("SumColumn","prefix") AS Alias
FROM tableSchema.tableName
FOR Oracle/MSSQL AS Source/Dest(FolderPath,FilePath,"tempSchema.tempTableName");

Note : prefix parameter in Sum() function is optional
Note : FOR must only have either Oracle or MSSQL
Note : Alias of FOR must only have either Source or Dest