Sometimes, we cannot simply give an id in the right part of the WITH clause, as the workaround suggests.

As an example, here is a test case implying dynamic linking to another table in the FROM clause.