when using planetscale, using the `.$with()` and `.with()` clauses causes error

Is it not possible to use $with() and with() with planetscale?
it gives the following error:
DatabaseError: unsupported: with expression in select statement
from the @planetscale/database package

you should ask PlanetScale that 🙂

i couldn't seem to find anything, but i'll try to push my google skills to the limit 🙂

yep, sorry