Add USING SCAN hint
Support NOT Expression

Without the braces (ie. NOT(Expression))
Renable semantic checking WITH clases
Fix ordering error with converting long chains to legacy query
Handle statements with no matches or updates