Redshift backup clause

[hsheth2]

from sqlglot import parse_one

parse_one(
    """
create table event_backup
backup yes
as
select * from event;
 """,
    read="redshift",
)

This triggers the command-based parsing fallback instead of parsing into a Create object: contains unsupported syntax. Falling back to parsing as a 'Command'.

Docs:

• https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html
• https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_AS.html

Seems like the backup yes clause needs to be recognized as a new exp.Property subtype.