What problem does this PR solve?

Problem Summary:

Some of the audit log are incorrect:
https://docs.google.com/spreadsheets/d/1E59z7busbRwjb2D20QLbmAGhLT75vec44HTB5vi2WrI/edit#gid=0

What is changed and how it works?

What's Changed:

Fix the following bugs:

• 'drop review' is not logged as 'drop table'
• 'create sesson binding' logged as 'explain'
• prepare statement operation is not logged
• 'trace' statement is logged as 'select'
• no audit log for 'shutdown' statement

How it Works:

Some are caused by AST not registed in GetStmtLabel()
Some are caused by the statement execute some other SQL internally and change the statement context

Check List

Tests

• Unit test
• Integration test
• Manual test (add detailed scripts or steps below)
• No code

Side effects

• Performance regression: Consumes more CPU
• Performance regression: Consumes more Memory
• Breaking backward compatibility

Documentation

• Affects user behaviors
• Contains syntax changes
• Contains variable changes
• Contains experimental features
• Changes MySQL compatibility

Release note

Fix some audit log that do not work as expected, including 'drop view'/'create session binding'/'prepare'/'trace'/'shutdown' etc