Add support for RESET statement

[watford-ep]

The RESET keyword is available, but the statement is not:

RESET configuration_parameter;
RESET ALL;

[watford-ep]

Notes:

• Per PR comments added this support to all parsers by default
• ANSI, BigQuery, Clickhouse, Hive, Snowflake, sqlite, and SQL Server do not support RESET in any form

Databricks

The RESET statement resets Databricks SQL parameters at the session level to the global default values if they were changed using the SET command. When using Databricks Runtime, parameters are known as SQL Conf properties.

RESET [ parameter_key ]

Duckdb

The RESET statement changes the given DuckDB configuration option to the default value.

RESET [ LOCAL | SESSION | GLOBAL ] configuration-option

MySQL

The RESET statement is used to clear the state of various server operations. You must have the RELOAD] privilege to execute RESET.

RESET reset_option [ , reset_option ] ...
-- reset_option: {
--     BINARY LOGS AND GTIDS
--  |  REPLICA
-- }

RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. For more information about persisting system variables and the mysqld-auto.cnf file, see Section 7.1.9.3, “Persisted System Variables”.

RESET PERSIST [ [ IF EXISTS ] system_var_name ]

Postgres

RESET — restore the value of a run-time parameter to the default value.

RESET { configuration_parameter | ALL }

Redshift

RESET restores the value of a configuration parameter to its default value.

You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the SET command. To display the current value of a parameter, use the SHOW command.)

RESET { parameter_name | variable_name | ALL }