ENG-6817: Enable CREATE ROLE via live DDL.  Add some basic testing.

-- Make an unclear error message a little less useless, see ENG-7185.
That horrible code is basically just looking for 'create role' to determine whether or not it's DDL.  The rest of the syntax will get validated downstream in the DDLCompiler.