[FEATURE] additional modifiers for CREATE VIEW

[davidjgoss]

Grammar or Syntax Description

Snowflake's CREATE VIEW includes standard modifiers but also:

• SECURE
• VOLATILE (alias for TEMPORARY)

SQL Example

CREATE OR REPLACE SECURE VIEW MY_VIEW AS SELECT COLUMN_1 FROM MY_TABLE;

CREATE VOLATILE VIEW MY_VIEW AS SELECT COLUMN_1 FROM MY_TABLE;

Additional context

• JSQLParser 4.8
• Snowflake
• Syntax docs https://docs.snowflake.com/en/sql-reference/sql/create-view