Support With Clause

[tlightsky]

https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions-syntax

[quattad]

Hi, could I check if there are any recent plans for WITH statements to be supported?

[samjewell]

I think an alternative workaround here is to use the parser in the Vitess project directly. Since PR vitessio/vitess#8918 it "Add parsing for common table expressions using WITH clause"

I think the SQL Parser can be imported with import "vitess.io/vitess/go/vt/sqlparser" - but I think the API is different - it doesn't seem to have a sqlparser.Parse('[string of SQL]') method any more.

EDIT I got this working. You can see how I used it here: grafana/grafana@3d952d0

It works fine on CTEs 🎉

[samjewell]

There's a second alternative workaround too - use DoltHub's hard-fork of the Vitess project, which is this one:
github.com/dolthub/[email protected]

I got this working too, here: grafana/grafana@45f9adf