The ALTER ROLE syntax is not supported

[r4ntix]

Background

The sqlparser-rs currently supported role syntax:

• create role ✅
• drop role ✅
• set role ✅
• alter role

Proposal

The syntax of PostgreSQL is as follows:

ALTER ROLE _`role_specification`_ [ WITH ] _`option`_ [ ... ]

where _`option`_ can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT _`connlimit`_
    | [ ENCRYPTED ] PASSWORD '_`password`_' | PASSWORD NULL
    | VALID UNTIL '_`timestamp`_'

ALTER ROLE _`name`_ RENAME TO _`new_name`_

ALTER ROLE { _`role_specification`_ | ALL } [ IN DATABASE _`database_name`_ ] SET _`configuration_parameter`_ { TO | = } { _`value`_ | DEFAULT }
ALTER ROLE { _`role_specification`_ | ALL } [ IN DATABASE _`database_name`_ ] SET _`configuration_parameter`_ FROM CURRENT
ALTER ROLE { _`role_specification`_ | ALL } [ IN DATABASE _`database_name`_ ] RESET _`configuration_parameter`_
ALTER ROLE { _`role_specification`_ | ALL } [ IN DATABASE _`database_name`_ ] RESET ALL

where _`role_specification`_ can be:

    _`role_name`_
  | CURRENT_ROLE
  | CURRENT_USER
  | SESSION_USER

The syntax of MS SQL Server is as follows:

ALTER ROLE  role_name  
{  
       ADD MEMBER database_principal  
    |  DROP MEMBER database_principal  
    |  WITH NAME = new_name  
}  
[;]

Implementation Plan

• add ALTER ROLE syntax of PostgreSQL ✅
• add ALTER ROLE syntax of MS SQL Server ✅
• add parser tests ✅

Addtional Context

Reference:

• MySQL :: MySQL 8.0 Reference Manual :: 6.2.10 Using Roles
• MySQL :: MySQL 8.1 Reference Manual :: 13.7.1.1 ALTER USER Statement
• Support CREATE ROLE and DROP ROLE by blx · Pull Request #598 · sqlparser-rs/sqlparser-rs (github.com)
• PostgreSQL: Documentation: 15: CREATE ROLE
• PostgreSQL: Documentation: 15: ALTER ROLE
• ALTER ROLE (Transact-SQL) - SQL Server | Microsoft Learn