prompt engineering

write a python program to do the following

1 - read in track.sql file as input
2 - parse ansi sql insert statements
3 - text columns should start and end with double quotes
  - remove N from start of unicode strings
4 - within a text column, replace commas with semicolons, 
    single and double quotes with the empty string

5 - Here is the list of columns.  Each output line needs all column values.
    [TrackId]
    [Name]
    [AlbumId]
    [MediaTypeId]
    [GenreId]
    [Composer]
    [Milliseconds]
    [Bytes]
    [UnitPrice]

6 - Some statements might have missing columns. 
    Make sure output has empty string for that column value.

7 - sample insert with a complete column list

Input 1:

INSERT INTO [dbo].[Track] ([TrackId], [Name], [AlbumId], [MediaTypeId], [GenreId], [Composer], [Milliseconds], [Bytes], [UnitPrice]) 
VALUES (3495, N'24 "Caprices", Op. 1, No. 24, for Solo Violin, in A Minor', 339, 2, 24, N'Niccolò Paganini', 265541, 4371533, 0.99);

Output 2:

3495,"24 Caprices Op. 1 No. 24 for Solo Violin in A Minor",339,2,24,"Niccolò Paganini",265541,4371533,0.99

8 - sample insert with a missing column

Input 2:

INSERT INTO [dbo].[Track] ([TrackId], [Name], [AlbumId], [MediaTypeId], [GenreId], [Milliseconds], [Bytes], [UnitPrice]) 
VALUES (3497, N'Erlkonig, D.328', 341, 2, 24, 261849, 4307907, 0.99);

Output 2:

3497,"Erlkonig; D.328",341,2,24,"",261849,4307907,0.99

9 - write a csv file named track.csv as output