feat: scopes for parameters in _pico_db_config

Summary

Added scopes to all parameters from _pico_db_config. There are two scopesright now - tier and global. Parameters with scope tier can be different on different tiers. For example ALTER SYSTEM SET parameter_with_scope_tier FOR ALL TIERS ALTER SYSTEM SET parameter_with_scope_tier FOR TIER default. Parameters with scope global are the same on each instance.

---

• Close #1172 (closed)
• Cherry-pick to: none
• Docs follow-up: docs#469 (closed)
• Changelog is updated