Support Transaction Statement

[HangyuanLiu]

• [Feature] Add Transaction Commit/Rollback logical and state #54218
• [Feature] Add Transaction syntax and statement #53976

Feature request

Is your feature request related to a problem? Please describe.

Describe the solution you'd like

Describe alternatives you've considered

Additional context