Is INSERT INTO ... SET standard SQL?
Apparently this is a MySQL extension, the SQL 2011 spec defines the insert grammar as,

&lt;insert statement&gt; ::=
INSERT INTO &lt;insertion target&gt; &lt;insert columns and source&gt;
14

&lt;insertion target&gt; ::=
&lt;table name&gt;

&lt;insert columns and source&gt; ::=
&lt;from subquery&gt;
| &lt;from constructor&gt;
| &lt;from default&gt;

&lt;from subquery&gt; ::=
[ &lt;left paren&gt; &lt;insert column list&gt; &lt;right paren&gt; ]
[ &lt;override clause&gt; ]
&lt;query expression&gt;

&lt;from constructor&gt; ::=
[ &lt;left paren&gt; &lt;insert column list&gt; &lt;right paren&gt; ]
[ &lt;override clause&gt; ]
&lt;contextually typed table value constructor&gt;

&lt;override clause&gt; ::=
OVERRIDING USER VALUE
| OVERRIDING SYSTEM VALUE

&lt;from default&gt; ::=
DEFAULT VALUES

&lt;insert column list&gt; ::=
&lt;column name list&gt;


You can see this talked about on the Pg Lists