Change check for legal part of CREATE TABLE AS SELECT ... WITH DATA plan

from a list of disallowed nodes to one of allowed nodes. Online DDL basically needs to be a vanilla table scan with filtering and projects.

Add a test for the case that brought this up.
So why do DMLStatement and InsertStatement need to be allowed through here?