Implement SQL standard Common Table Expression (CTE) support

Description

It would be great if MariaDB supported SQL standard Common Table Expressions (CTEs).

1 2 3 4 5 6 7 8 9 WITH moved_rows AS ( DELETE FROM products WHERE "date" >= '2010-10-01' AND "date" < '2010-11-01' RETURNING * ) INSERT INTO products_log SELECT * FROM moved_rows;

Environment

None

Status

Assignee

Unassigned

Reporter

Geoff Montee

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Priority

Major