Add SQL script creation to tables

Question

Now that we can finally use formatted tables in questions and answers, I suggest enhancing the feature to also optionally generate an SQL CREATE+INSERT script for each table in a question.

We can use the question tags as a trigger, where any question tagged sql would have an extra small link at the bottom of a table. Clicking the link would run JavaScript code to generate the SQL on the client, and either show the script or put it in the clipboard. Datatypes would either be inferred or always varchar (I'd much rather just change a few datatype declarations than type a whole script).

This would make it easier to answer questions for people by letting us more quickly set up testing and example tables on sites like SQL Fiddle, db<>fiddle, etc.

An advanced option or stretch goal would be smart enough to see tags like mysql or sql-server, and know the different variations in SQL syntax between the databases.

Answer 1

I am not sure if Stack Exchange will implement this feature request. I suggest you to use https://tableconvert.com/markdown-to-sql.

The website helps you to convert Markdown tables to SQL queries.

For example, this is my Markdown table:

What?	When?	Where?
Table support	2020-11-23	Meta Stack Exchange & DBA Meta
More table support	week of 2020-11-30	DBA Stack Exchange
Even more table support	week of 2020-12-07	Network-wide launch (if no major issues found)

The website gives us these queries:

CREATE TABLE tableName 
(
    What?   varchar(300),
    When?   varchar(300),
    Where?  varchar(300)
);

INSERT INTO tableName (What?,When?,Where?)
VALUES
    ('Table support', '2020-11-23', 'Meta Stack Exchange & DBA Meta'),
    ('More table support', 'week of 2020-11-30', 'DBA Stack Exchange'),
    ('Even more table support', 'week of 2020-12-07', 'Network-wide launch (if no major issues found)');