Introduced use_same_password_for_base_backup settings for BACKUP and RESTORE queries

Why it matters

This feature solves the problem of securely managing incremental backups by allowing users to protect their backup archives with a password and use the same password consistently for both backup and restore operations. It enhances data security and simplifies the process of handling encrypted backup files.

How to use it

To use this feature, set the use_same_password_for_base_backup setting to true when executing BACKUP or RESTORE queries. This will enforce the usage of the same password for creating and restoring password-protected incremental backups.