Last I checked MariaDB doesn't support common table expressions which are part of the SQL standard published in 1999, nearly 20 years ago. Has this changed?
If SQL is SQL is SQL as you say, then I would say MariaDB doesn't support SQL.
If SQL is SQL is SQL as you say, then I would say MariaDB doesn't support SQL.