SQL statement extension support in AT mode

## Why you need it?
Is your feature request related to a problem? Please describe in details

Currently, the AT transaction mode supports a limited number of SQL statements. For details, see: https://seata.io/zh-cn/docs/user/sqlreference/sql-restrictions.html . SQL statement support needs to be further extended to meet application requirements.

目前，AT事务模式支持有限的SQL语句，具体参考：https://seata.io/zh-cn/docs/user/sqlreference/sql-restrictions.html 。需要进一步扩展SQL的语句支持来满足应用的需求。

Tasks are divided by SQL statement dimensions
任务将以SQL维度划分。

## How it could be?
A clear and concise description of what you want to happen. You can explain more about input of the feature, and output of it.

## Other related information
Add any other context or screenshots about the feature request here.

Start with the SQL restrictions reference linked in the issue and compare it with the AT transaction mode's currently supported statements. The issue does not identify a statement, source file, or test; clarify which SQL dimension is in scope before locating the implementation. Done means the selected statement support is implemented and verified for AT mode.

Written by the indexing model from the issue text.