Expand `TABLE` command support

#704 added support for the `CREATE TABLE x AS TABLE y` by adding basic support for the `TABLE` command within the context of a `CREATE` statement. However, as noted in the [Postgres docs](https://www.postgresql.org/docs/current/sql-select.html#SQL-TABLE):

"It can be used as a top-level command or as a space-saving syntax variant in parts of complex queries. Only the WITH, UNION, INTERSECT, EXCEPT, ORDER BY, LIMIT, OFFSET, FETCH and FOR locking clauses can be used with TABLE; the WHERE clause and any form of aggregation cannot be used."

These other cases have yet to be investigated.

Review the existing TABLE support introduced by #704 alongside the PostgreSQL TABLE documentation. Identify which top-level and allowed-clause cases remain unsupported; done means the intended cases are parsed consistently and covered by the repository's tests.

Written by the indexing model from the issue text.