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.