...

Proposed Changes

For REPLACE TABLE AS  statement:

1:  Construct the table to be created

a:  if  If the column definition is specificed, it will use the defined column to  create the new table.  Otherwise, it'll retrieve the column definition from the sub-query.

2:

b3:

Describe the new thing you want to do in appropriate detail. This may be fairly extensive and have large subsections of its own. Or it may be a few sentences. Use judgement based on the scope of the changeFor CREATE OR REPLACE TABLE AS  stament,  when the table exists, it'll consider it as REPLACE TABLE AS  statement. Otherwise, it'll consider it as CREATE TABLE AS  statement.

Compatibility, Deprecation, and Migration Plan

...