feat: support ALTER SYSTEM. It allows to change whitelisted properties from _pico_property table. Currently, changes affect all tiers. Specifying tier will result in an error.

Co-Authored-by: Dmitry Rodionov <d.rodionov@picodata.io>

Co-Authored-by: Emir Vildanov <e.vildanov@picodata.io>

Arseniy Volynets authored 8 months ago and Arseniy Volynets committed 7 months ago

- Normalize name to lowercase from parser
- Identifiers are stored as normalized strings
without quotes
- During conversion to local SQL we wrap
identifiers in quotes, because tarantool
normalizes names without quotes to uppercase
- For errors and explain, we also need to
wrap names into quotes for better readability

Affected diagrams:
— expression
— literal
— call
— type

Extracted diagrams:
— case
— to_char
— to_date
— trim

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L205-208

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L173-179

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L186