INSERT INTO

SQL standard specifies the following CREATE TABLE syntax:

INSERT INTO table_name

All dialects (except Hive) suppurt this syntax, plus a bunch of extra stuff:

BigQuery:

INSERT [INTO] table_name

DB2:

INSERT INTO table_name

Hive:

INSERT INTO TABLE table_name

MariaDB:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] table_name

REPLACE [LOW_PRIORITY | DELAYED] [INTO] table_name

MySQL:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] table_name

REPLACE [LOW_PRIORITY | DELAYED] [INTO] table_name

N1QL:

INSERT INTO table_name

PL/SQL:

INSERT [hint] {INTO | multi_table_insert}

multi_table_insert:
  | ALL INTO
  | [ALL | FIRST] WHEN condition THEN INTO

PostgreSQL:

INSERT INTO table_name

Redshift:

INSERT INTO table_name

SingleStoreDB:

INSERT [IGNORE] [INTO] table_name

REPLACE [INTO] table_name

Snowflake:

INSERT [OVERWRITE] { INTO tablename | multi_table_insert}

multi_table_insert:
  | ALL INTO tablename
  | [ALL | FIRST] case_insert [ ... ]

case_insert:
  | WHEN condition THEN INTO tablename
  | ELSE INTO tablename

Spark:

INSERT [INTO | OVERWRITE] [TABLE] table_name

SQLite:

INSERT [OR {ABORT | FAIL | IGNORE | REPLACE | ROLLBACK}] INTO table_name

REPLACE INTO table_name

TiDB:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] table_name

REPLACE [LOW_PRIORITY | DELAYED] [INTO] table_name

Transact-SQL:

INSERT [TOP ( expression ) [PERCENT]] [INTO] table_name

Trino:

INSERT INTO table_name