> I have searched SQL documentation and unless I am missing something, 'with' is not a keyword that would cause confusion.

I'm not sure where you were looking but WITH is a SQL reserved keyword.