MDEV-34391 Implement SET PATH statement

[wong-github1]

trafficstars

• [x] *The Jira issue number for this PR is: MDEV-34391

Description

Implement the SET PATH statement.

Release Notes

Implement the SET PATH statement.

How can this PR be tested?

mysql-test/mtr path_basic

Basing the PR against the correct MariaDB version

• [x] This is a new feature or a refactoring, and the PR is based against the main branch.
• [ ] This is a bug fix, and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [x] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [x] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.