added sqlstatements to mask/delete/truncate tables

[elcoda]

If you are interested we developed an extra config .json files to execute arbitrary SQL statements during masking. We use them to truncate tables on our db or to do some batch updates on them.

Have a look to sqlStatements on the following json example:

{
    "dataSource": {
        "type": "SqlServer",
        "config": {
            "connectionString": "Data Source=xxxxxxxxxxxxxxxxxxxxxxxx"
        }
    },
    "dataGeneration": {
        "locale": "it"
    },
    "tables": [
        {
            "name": "zero_table",
            "primaryKeyColumn": "id",
            "columns": [
              {
                "name": "Note",
                "type": "Sql",
                "sqlValue": {
                  "query": "select 1"
    
                }
              }
            ]
        }
    ],

    "sqlStatements": [
        {
            "name": "SqlVolante",
            "statement": "Truncate table first_table"
        },
        {
            "name": "SqlVolante1",
            "statement": "Truncate table second_table"
        }
    ]
}