Extract Data from SQL INSERT Statements in C#

using System;
using System.IO;
using System.Text.RegularExpressions;

class SQLParser
{
    // Main method to execute the program
    static void Main(string[] args)
    {
        // Define the path of the input SQL file
        string inputFilePath = "input.sql"; // Path to the SQL file containing the INSERT commands
        
        // Read all lines from the input SQL file
        string[] lines = File.ReadAllLines(inputFilePath);

        // Open a new file to write the formatted output
        using (StreamWriter writer = new StreamWriter("output.txt"))
        {
            // Loop through each line in the input SQL file
            foreach (string line in lines)
            {
                // Check if the line is a valid INSERT INTO statement
                if (line.StartsWith("INSERT INTO", StringComparison.OrdinalIgnoreCase))
                {
                    // Extract the table name using a regular expression
                    string tableName = Regex.Match(line, @"INSERT INTO (\w+)").Groups[1].Value;

                    // Extract the field names from the line (text between parentheses)
                    string fields = Regex.Match(line, @"\(([^)]+)\)").Groups[1].Value;

                    // Extract the values for the fields (text after 'VALUES' keyword)
                    string values = Regex.Match(line, @"VALUES \(([^)]+)\)").Groups[1].Value;

                    // Split the field names and values into arrays
                    string[] fieldNames = fields.Split(',');
                    string[] fieldValues = values.Split(',');

                    // Write the table name to the output file
                    writer.WriteLine($"Table: {tableName}");

                    // Loop through the field names and corresponding values
                    for (int i = 0; i < fieldNames.Length; i++)
                    {
                        // Trim spaces from the field names and values
                        string fieldName = fieldNames[i].Trim();
                        string fieldValue = fieldValues[i].Trim();

                        // Remove the surrounding quotes from string values
                        if (fieldValue.StartsWith("\"") && fieldValue.EndsWith("\""))
                        {
                            fieldValue = fieldValue.Substring(1, fieldValue.Length - 2);
                        }

                        // Write the field name and its corresponding value to the output file
                        writer.WriteLine($"{fieldName}: {fieldValue}");
                    }

                    // Add a blank line after each record
                    writer.WriteLine();
                }
            }
        }

        // Notify the user that the operation is complete
        Console.WriteLine("SQL parsing is complete. Check the output.txt file.");
    }
}

 Output

//Output (If the input file contains the following lines):
INSERT INTO people (name, address, age) VALUES ("smith, pedro", "your street", 23);
INSERT INTO people (name, address, age) VALUES ("juan", "calle cinco, 6", 24);
INSERT INTO cities (code, name) VALUES ("a", "alicante");

//Contents of output.txt:
Table: people
name: smith, pedro
address: your street
age: 23

Table: people
name: juan
address: calle cinco, 6
age: 24

Table: cities
code: a
name: alicante