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.
You can do the following?
```sql
CREATE TABLE tab AS (INSERT INTO people (3,'Bobby'),(40,'Jackie')) WITH DATA;
```