using System;

using Newtonsoft.Json;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

//      List<QResult> resList = new List<QResult>(){new QResult(){SchemaName="dbo", TableName="tbl",ColName="col",TypeOfContent="TT", Severity="GDPR"},new QResult(){SchemaName="dbo", TableName="tbl",ColName="col2",TypeOfContent="TT", Severity="GDPR"}};

//      Console.WriteLine("Hello World");

        //string jsonString = JsonConvert.SerializeObject(resList, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore, Formatting = Formatting.Indented });

    //  jsonString.Dump();

    //  resList.Dump();

        string ss = "[[\"dbo\",\"ABTSpecials\",\"pcppayment_dec\",\"Financial\",\"Confidential\"],[\"dbo\",\"Addresses\",\"street_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"BusinessManagers\",\"email_addr_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"CarCare_policies\",\"ExpiryDate\",\"CreditCard\",\"Confidential\"],[\"dbo\",\"CarCare_policies\",\"Surname\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"CarCareData\",\"Customersurname\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"CarCareData\",\"Expirydate\",\"CreditCard\",\"Confidential\"],[\"dbo\",\"CarCareData\",\"insurancetype_ch\",\"Financial\",\"Confidential\"],[\"dbo\",\"Customers\",\"allow_phone_contact_bit\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"email_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"existing_medical_condition_bit\",\"Health\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"first_name_vch\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"increase_critical_insurance_bit\",\"Financial\",\"Confidential\"],[\"dbo\",\"Customers\",\"increase_life_insurance_bit\",\"Financial\",\"Confidential\"],[\"dbo\",\"Customers\",\"mobile_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"prev_surname_vch\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"surname_vch\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Customers\",\"telephone_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_county_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_district_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_house_name_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_house_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_postcode_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_street_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"address_town_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"email_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Dealers\",\"telephone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"accountant_tel_vch\",\"Financial\",\"Confidential\"],[\"dbo\",\"Employers\",\"accountant_vch\",\"Financial\",\"Confidential\"],[\"dbo\",\"Employers\",\"addr_country_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_county_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_district_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_house_name_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_house_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_postcode_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_premises_name_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_street_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"addr_town_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"telephone_ext_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Employers\",\"telephone_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProducts\",\"doc_fee_is_first_payment\",\"Financial\",\"Confidential\"],[\"dbo\",\"FinanceProducts\",\"min_amount_dec\",\"Financial\",\"Confidential\"],[\"dbo\",\"FinanceProducts\",\"repayment_supplement_dec\",\"Financial\",\"Confidential\"],[\"dbo\",\"FinanceProviders\",\"address_county_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_district_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_house_name_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_house_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_postcode_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_street_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"address_town_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"email_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceProviders\",\"telephone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FinanceRequests\",\"payments_dec\",\"Financial\",\"Confidential\"],[\"dbo\",\"FinanceRequests\",\"postal_code_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"FunderInfo\",\"password_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"FunderInfo\",\"username_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"FunderInfo_old\",\"password_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"FunderInfo_old\",\"username_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"FunderInfoBackup\",\"password_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"FunderInfoBackup\",\"username_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"insurance_product_costs\",\"insurance_cost_id_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"insurance_product_costs\",\"insurance_type_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"insurance_type\",\"insurance_type_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceProducts\",\"insuranceprovider_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceProducts\",\"insurancetype_ch\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceProducts_BK_20170901\",\"insuranceprovider_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceProducts_BK_20170901\",\"insurancetype_ch\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceProviders\",\"address_county_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_district_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_house_name_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_house_no_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_postcode_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_street_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"address_town_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"email_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceProviders\",\"telephone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"InsuranceRequests\",\"InitialPaymentTaken\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceRequests\",\"insuranceproductid_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceRequests\",\"payments_int\",\"Financial\",\"Confidential\"],[\"dbo\",\"InsuranceRequests\",\"tax_dec\",\"Financial\",\"Confidential\"],[\"dbo\",\"MbfsFullRVImports\",\"VATTreatment\",\"Health\",\"Confidential-GDPR\"],[\"dbo\",\"MbfsRegVinMapping\",\"Capacity\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"MbfsRegVinMapping\",\"Currency\",\"Financial\",\"Confidential\"],[\"dbo\",\"MDSalesLog\",\"invoice_no_vch\",\"Financial\",\"Confidential\"],[\"dbo\",\"NewAlpheraIDs\",\"NewPassword\",\"Credentials\",\"Confidential\"],[\"dbo\",\"NewAlpheraIDs\",\"OldPassword\",\"Credentials\",\"Confidential\"],[\"dbo\",\"NewNorthridgeCodes\",\"Address1\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"NewNorthridgeCodes\",\"Address2\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"NewNorthridgeCodes\",\"City/Town\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"NewNorthridgeCodes\",\"Telephone\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Address1\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Address2\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Address3\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Address4\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Address5\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"EmailAddress\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"FirstName\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"HomePhoneNumber\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"MobilePhoneNumber\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"Surname\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"QM_Customers\",\"WorkPhoneNumber\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"QM_QuoteItems\",\"NumberOfPayments\",\"Financial\",\"Confidential\"],[\"dbo\",\"Sales\",\"invoice_no_vch\",\"Financial\",\"Confidential\"],[\"dbo\",\"SAPResults\",\"AmountFinanced\",\"Financial\",\"Confidential\"],[\"dbo\",\"SAPResults\",\"Surname\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"CellPhone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"FirstName_vch\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"HomePhone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"LastName_vch\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"StreetAddr_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"TownCity_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Siebel_Referred_Or_Sold_Leads\",\"WorkPhone_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_AddedValue\",\"InsuranceProductID\",\"Financial\",\"Confidential\"],[\"dbo\",\"Stacker_CustomerDetails\",\"DOB\",\"DateOfBirth\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"Email\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"FirstName\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"Mobile\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"Street\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"Surname\",\"Name\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_CustomerDetails\",\"Telephone\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Finance\",\"MonthlyPayment\",\"Financial\",\"Confidential\"],[\"dbo\",\"Stacker_Order_CustomerDetails\",\"DOB\",\"DateOfBirth\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Order_CustomerDetails\",\"Email\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Order_CustomerDetails\",\"Mobile\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Order_CustomerDetails\",\"Street\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Order_CustomerDetails\",\"Telephone\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Stacker_Order_PartEx\",\"MotExpiry\",\"CreditCard\",\"Confidential\"],[\"dbo\",\"Targets\",\"insurance_type\",\"Financial\",\"Confidential\"],[\"dbo\",\"Users\",\"ad_account_vch\",\"Financial\",\"Confidential\"],[\"dbo\",\"Users\",\"email_vch\",\"ContactInfo\",\"Confidential-GDPR\"],[\"dbo\",\"Users\",\"password_expires_dt\",\"Credentials\",\"Confidential\"],[\"dbo\",\"Users\",\"password_vch\",\"Credentials\",\"Confidential\"],[\"dbo\",\"Vehicles\",\"insurance_fee\",\"Financial\",\"Confidential\"]]";

        var dd  = Newtonsoft.Json.JsonConvert.DeserializeObject<List<List<string>>>(ss);

        //dd.Dump();

JsonConvert.SerializeObject(dd.Select(d=>new []{d[0], d[1], d[2]})).Dump();

        dd.Select(d=>string.Join(";",d)+"; SELECT " + d[2] + ", * FROM " + d[0] + "." + d[1] ).Dump(); 

    }

}

​

public class QResult

{

    public string SchemaName{get;set;}

    public string TableName{get;set;}

    public string ColName{get;set;}

    public string TypeOfContent {get;set;}

    public string Severity {get;set;}

}