Query fails on macOS, while on ubuntu it is fine.

What happend?

In ampersand we programatically generate ansi-sql. Recently, I added a feature to be able to generate transitive closures as well. The generation is done from an expression in a domain specific language based on set theory.
During the implementation I found out that a `with recursive` construct cannot be used as subquery everywhere where a `select` subquery can be used (See this issue for details. @Rex Jonston was kind enough to suggest an alternative, that perfectly fits in the way the generation is done.
The suggestion was to wrap the `with recursive` subquery, yealding `select * from <with-recursive-subquery>`.

So I did. The generation is fine, MariaDB vs 11.5 accepts the generated query in ubuntu, but on MacOS it rejects the exact same query. (we run our testcases both in ubuntu 22.04 as well as macos 13.)

The testcases are run using github actions. The log of the failing run can be found here

What did I expect?

I expected MariaDB to behave the same under macOS as under ubuntu.