feature: add plugins query

Summarize the changes

RFC: https://docs.google.com/document/d/1zfpo-oaprdQGvxXuJbnFMEhvM3Ug_8qFY9sftU2MIJs

PLUGIN RFC: https://docs.google.com/document/d/1QMFXWhrSJ9VLFNX-jayHCzG8jk01VwtOuTOzooBBsOA/edit#heading=h.ue9yhktcy3oc

Picodata issue: picodata#664 (closed)

Picodata mr: picodata!1163 (merged)

New queries:

• CREATE PLUGIN
• DROP PLUGIN
• ALTER PLUGIN ENABLE
• ALTER PLUGIN DISABLE
• ALTER PLUGIN MIGRATE TO
• ALTER PLUGIN ADD TIER
• ALTER PLUGIN REMOVE TIER
• ALTER PLUGIN SET (config key value)

Ensure that

• New code is covered by unit and integration tests.
• Related issues would be automatically closed with gitlab's closing pattern (Closes #1, #2).
• Public modules are documented (check the rendered version with cargo doc --open).
• (if PEST grammar is changed) EBNF grammar reflects these changes (check the result with railroad diagram generator.

Next steps

• Cherry-pick to: none
• Update sbroad submodule in picodata/picodata. picodata!1163 (merged)
• (if EBNF grammar is changed) create a follow-up issue in picodata/docs - docs#349 (closed)

doc/sql/query.ebnf

@@ -106,17 +106,18 @@ grant       ::= 'GRANT' (
                     | role
                 )
                 'TO' (role | user)
-ddl         ::= (alter_procedure | create_index | create_procedure | create_table
-                | drop_index | drop_procedure | drop_table | alter_system)
-                ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+ddl         ::= (alter_plugin | alter_procedure | alter_system
+                | create_index | create_plugin | create_procedure | create_table
+                | drop_index | drop_plugin | drop_procedure | drop_table)
 alter_system ::= 'ALTER' 'SYSTEM'
                     (
                         'RESET' ('ALL' | param_name)
                         | 'SET' param_name ('=' | 'TO') ('DEFAULT' | param_value)
                     )
                     ('FOR' ('ALL' 'TIERS' | 'TIER' tier))?
+                  ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 alter_procedure ::= 'ALTER' 'PROCEDURE' procedure ('(' type (',' type)* ')')?
-                     'RENAME' 'TO' procedure
+                     'RENAME' 'TO' procedure ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 create_index ::= 'CREATE' 'UNIQUE'? 'INDEX' index 'ON' table
                  ('USING' ('TREE' | 'HASH' | 'RTREE' | 'BITSET'))?
                  '(' column (',' column)* ')' ('WITH' '('
@@ -143,12 +144,12 @@ create_index ::= 'CREATE' 'UNIQUE'? 'INDEX' index 'ON' table
                              | ('HINT' '=' ('TRUE' | 'FALSE'))
                          )
                      )*
-                 ')')?
+                 ')')? ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 create_procedure ::= 'CREATE' 'PROCEDURE' procedure '(' type (',' type)* ')'
                      ('LANGUAGE' 'SQL')? (
                          ('AS' '$$' (insert | update | delete) '$$')
                          | ('BEGIN' 'ATOMIC' (insert | update | delete) 'END')
-                     )
+                     ) ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 create_role    ::= 'CREATE' 'ROLE' role
 create_table   ::= 'CREATE' 'TABLE' table
                    '('
@@ -157,6 +158,7 @@ create_table   ::= 'CREATE' 'TABLE' table
                    ')'
                    ('USING' ('MEMTX' | 'VINYL'))?
                    (('DISTRIBUTED' (('BY' '(' column (',' column)* ')' ('IN' 'TIER' tier)?) | 'GLOBALLY'))?)?
+                   ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 create_user    ::= 'CREATE' 'USER' user 'WITH'? 'PASSWORD' "'" password "'"
                    ('USING' ('CHAP-SHA1' | 'LDAP' | 'MD5'))?
 alter_user     ::= 'ALTER' 'USER' user
@@ -166,11 +168,29 @@ alter_user     ::= 'ALTER' 'USER' user
                        | 'PASSWORD' "'" password "'" ('USING' ('CHAP-SHA1' | 'LDAP' | 'MD5'))?
                        | 'RENAME' 'TO' user
                    )
-drop_index     ::= 'DROP' 'INDEX' index
-drop_procedure ::= 'DROP' 'PROCEDURE' procedure ('(' type (',' type)* ')')?
-drop_table     ::= 'DROP' 'TABLE' table
+drop_index     ::= 'DROP' 'INDEX' index ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+drop_procedure ::= 'DROP' 'PROCEDURE' procedure ('(' type (',' type)* ')')? ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+drop_table     ::= 'DROP' 'TABLE' table ('OPTION' '(' ('TIMEOUT' '=' double)')')?
 drop_role      ::= 'DROP' 'ROLE' role
 drop_user      ::= 'DROP' 'USER' user
+create_plugin  ::= 'CREATE' 'PLUGIN' ('IF' 'NOT' 'EXISTS')? plugin version
+                    ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+drop_plugin    ::= 'DROP' 'PLUGIN' ('IF' 'EXISTS')? plugin version ('WITH' 'DATA')?
+                    ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+alter_plugin  ::= 'ALTER' 'PLUGIN' plugin (
+                        (version (
+                            'ENABLE' | 'DISABLE'
+                            | ('ADD' 'SERVICE' service 'TO' 'TIER' tier)
+                            | ('REMOVE' 'SERVICE' service 'FROM' 'TIER' tier)
+                            | ('SET' ((service'.'key '=' text) (',' service'.'key '=' text)*))
+                        ))
+                        ('OPTION' '(' ('TIMEOUT' '=' double)')')?
+                        | ('MIGRATE' 'TO' version)
+                          ( 'OPTION' '('
+                            (('TIMEOUT' | 'ROLLBACK_TIMEOUT') '=' double)
+                            (',' (('TIMEOUT' | 'ROLLBACK_TIMEOUT') '=' double))*')'
+                          )?
+                   )
 type        ::= 'BOOL'
                 | 'BOOLEAN'
                 | 'DATETIME'