sebastienros/parlot#255 introduces a sample SqlParser. This can be used to replace the current one made with Irony. This should be faster and easier to maintain (it uses a concrete AST).

The remaining work is to copy the SqlParser and SqlAst from Parlot, then replace what is currently named SqlParser in OrchardCore to SqlTranslator, which is the part converting the standard AST to the SQL string in the target dialect. The code should be straightforward and simpler since instead of checking node types we can just browse the properties of the new AST.

Don't do it all at once, for instance keep the CTE for the end once the rest is working (might be more complicated).