Ah yes. Common table expressions, my most loved feature from the 1999 SQL specification. Has MariaDB added support for them yet?
https://mariadb.com/kb/en/the-mariadb-library/mariadb-1021-r... https://mariadb.com/kb/en/the-mariadb-library/mariadb-1022-r...