SQL insert generator from a CSV/TSV list

[celluj34]

What feature or new tool do you think should be added to DevToys?

I would like to see a "SQL Insert Generator" tool, similar to https://tableconvert.com/excel-to-sql, that would take a list of CSV or TSV separated values and create a statement or statements that would insert to a specified table.

Why do you think this is needed?

It would help ensure our data isn't going somewhere "outside" as the website only works with copy/paste or file upload, and being able to generate a large list of inserts is helpful when I need to manually bulk upload some data.

Solution/Idea

The solution would simply take a list, split by ',' or '\t', and concat them into a list of INSERT (...) VALUES (...) or (optionally) one INSERT with many VALUES records. Optional features could be a column name and type editor, or creating a temp table for the duration of the sql command.

Comments

Microsoft SQL has a limit of 1,000 VALUES entries at a time, so it'd also be cool to be able to specify a limit or 'chunk' the inserts by a specific number. It would also be neat to be able to specify the column types, but that's easy enough to do outside of the tool.

[gordon-matt]

You can use my extension for this: DevToys Code Generator

You want to use the CSV Input Generator, then modify the template to something like this:

Also available are generators based on JSON input or a simple list of strings