VALUES and TABLE statements

[kennytm]

Feature Request

Is your feature request related to a problem? Please describe:

MySQL 8 compatibility.

Describe the feature you'd like:

The TABLE and VALUES statements are two query specification statements introduced in MySQL 8.0.19.

TABLE tbl_name [ORDER BY col_name] [LIMIT limit [OFFSET offset]];

VALUES ROW(val1, val2, …), … [ORDER BY column_N [LIMIT limit [OFFSET offset]]];

These can be used in place everywhere a SELECT statement was expected, including:

• UNION
• JOIN
• subqueries
• SELECT INTO OUTFILE
• INSERT INTO SELECT
• CREATE TABLE SELECT

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy: