Appendix: Complete list of SQL types supported by general_sql_command

ALTER_RESOURCE_POOL
ALTER_RESOURCE_UNIT
ALTER_TABLE
ALTER_VIEW
ALTER_SYSTEM
ALTER_SYSTEM_SETTP
ADD_UPDATESERVER
ADMIN_SERVER
ADMIN_ZONE
ADMIN_MERGE
ALTER_DATABASE
ALTER_TABLEGROUP
ALTER_OUTLINE
ADMIN_UPGRADE_CMD
ALTER_ROUTINE
ANONYMOUS_BLOCK
ALTER_PACKAGE
ANALYZE
ALTER_SEQUENCE
ALTER_DISKGROUP_ADD_DISK
ALTER_DISKGROUP_DROP_DISK
ADD_CLUSTER
ALTER_SYSTEM_SET_PARAMETER
ALTER_KEYSTORE
ALTER_ROLE
ALTER_USER_PROFILE
AUDIT
ALTER_CLUSTER
ARCHIVE_LOG
ALTER_TABLESPACE
ADMIN_ROLLING_UPGRADE_CMD
ALTER_PROFILE
ALTER_USER
ALTER_TRIGGER
ALTER_USER_PRIMARY_ZONE
ALTER_TYPE
ADMIN_RECOVERY
ADMIN_RUN_UPGRADE_JOB
ADMIN_STOP_UPGRADE_JOB
ADD_RESTORE_SOURCE
ALTER_RESOURCE_TENANT
ARCHIVE_TENANT
ADD_ARBITRATION_SERVICE
ALTER_SYSTEM_RESET_PARAMETER
ALTER_LS_REPLICA
ALTER_USER_PROXY
ALTER_SERVER
ALTER_LOGFILE_GROUP
ADMIN_STORAGE
ALTER_LS
ALTER_CATALOG
ALTER_LOCATION
ALTER_SENSITIVE_RULE

BOOTSTRAP
BUILD_INDEX_SSTABLE
BACKUP_DATABASE
BACKUP_MANAGE
BACKUP_BACKUPSET
BACKUP_ARCHIVELOG
BACKUP_CLEAN
BACKUP_SET_ENCRYPTION
BACKUP_SET_DECRYPTION
BACKUP_BACKUPPIECE
BACKUP_KEY
BACKUP_CLUSTER_PARAMETERS

CREATE_TENANT
CHANGE_TENANT
CREATE_RESOURCE_POOL
CREATE_RESOURCE_UNIT
CREATE_TABLE
CREATE_INDEX
CREATE_VIEW
CREATE_USER
CHANGE_OBI
CS_DISKMAINTAIN
CLUSTER_MANAGER
CLEAR_MEMTABLE
CHECK_ROOT_TABLE
CLEAR_ROOT_TABLE
CREATE_DATABASE
CREATE_TABLEGROUP
CREATE_TABLE_LIKE
CLEAR_LOCATION_CACHE
CLEAR_MERGE_ERROR
CREATE_OUTLINE
CREATE_ROUTINE
CALL_PROCEDURE
CREATE_PACKAGE
CREATE_PACKAGE_BODY
CANCEL_TASK
CREATE_SYNONYM
CLEAR_BALANCE_TASK
CREATE_FUNC
CREATE_SEQUENCE
CREATE_TYPE
CREATE_SAVEPOINT
CREATE_KEYSTORE
CREATE_TABLESPACE
CREATE_TRIGGER
CREATE_ROLE
CREATE_DBLINK
CREATE_PUB_SYNONYM
CREATE_PROFILE
CREATE_RESTORE_POINT
CLEAR_RESTORE_SOURCE
CREATE_DIRECTORY
CREATE_CONTEXT
CHECKPOINT_SLOG
CREATE_STANDBY_TENANT
CANCEL_RESTORE
CANCEL_RECOVER_TABLE
CREATE_TENANT_SNAPSHOT
CLONE_TENANT
CANCEL_CLONE
CREATE_MLOG
CHANGE_EXTERNAL_STORAGE_DEST
CHECKSUM_TABLE
CREATE_SERVER
CREATE_LOGFILE_GROUP
CACHE_INDEX
CREATE_CATALOG
CREATE_CCL_RULE
CREATE_LOCATION
CREATE_SENSITIVE_RULE

DROP_TENANT
DROP_RESOURCE_POOL
DROP_RESOURCE_UNIT
DROP_TABLE
DROP_INDEX
DROP_VIEW
DROP_USER
DEALLOCATE
DROP_MEMTABLE
DELETE_UPDATESERVER
DROP_DATABASE
DROP_TABLEGROUP
DROP_OUTLINE
DROP_ROUTINE
DROP_PACKAGE
DROP_SYNONYM
DROP_FUNC
DROP_SEQUENCE
DROP_TYPE
DROP_TABLESPACE
DROP_TRIGGER
DROP_ROLE
DROP_DBLINK
DROP_PUB_SYNONYM
DROP_PROFILE
DIAGNOSTICS
DELETE_POLICY
DISABLE_SQL_THROTTLE
DROP_RESTORE_POINT
DROP_DIRECTORY
DISCONNECT_CLUSTER
DROP_CONTEXT
DROP_TENANT_SNAPSHOT
DROP_MLOG
DROP_SERVER
DROP_LOGFILE_GROUP
DROP_CATALOG
DROP_CCL_RULE
DROP_LOCATION
DROP_SENSITIVE_RULE

EXECUTE
END_TRANS
EMPTY_QUERY
ENABLE_SQL_THROTTLE
EVENT_JOB_CREATE
EVENT_JOB_ALTER
EVENT_JOB_DROP

FREEZE
FLUSH_CACHE
FLUSH_KVCACHE
FLUSH_ILOGCACHE
FLASHBACK_TENANT
FLASHBACK_DATABASE
FLASHBACK_TABLE_FROM_RECYCLEBIN
FLASHBACK_INDEX
FLASHBACK_TABLE_TO_SCN
FLUSH_DAG_WARNINGS
FLUSH_PRIVILEGES
FLUSH_MOCK
FLUSH_MOCK_LIST
FLUSH_SS_MICRO_CACHE
FLASHBACK_STANDBY_LOG
FLUSH_TABLE_MOCK
FLUSH_SS_LOCAL_CACHE

GRANT
GRANT_ROLE
GRANT_PROXY

HELP
HANDLER_MOCK
HBASE_SCAN
HBASE_PUT
HBASE_DELETE
HBASE_APPEND
HBASE_INCREMENT
HBASE_CHECK_AND_PUT
HBASE_CHECK_AND_DELETE
HBASE_HYBRID_BATCH
HBASE_OTHER
HBASE_CHECK_AND_MUTATE
HBASE_GET
HBASE_BATCH_PUT
HBASE_BATCH_DELETE
HBASE_BATCH_GET

INSTALL_PLUGIN

KILL
KV_INSERT
KV_GET
KV_DELETE
KV_UPDATE
KV_INSERT_OR_UPDATE
KV_REPLACE
KV_INCREMENT
KV_APPEND
KV_PUT
KV_MULTI_GET
KV_MULTI_INSERT
KV_MULTI_DELETE
KV_MULTI_UPDATE
KV_MULTI_INSERT_OR_UPDATE
KV_MULTI_REPLACE
KV_MULTI_INCREMENT
KV_MULTI_APPEND
KV_MULTI_PUT
KV_QUERY
KV_QUERY_AND_MUTATE
KV_OTHER

LOCK_TENANT
LOCK_USER
LOAD_TIME_ZONE_INFO
LOAD_DATA
LOGIN
LOGOFF
LOCK_TABLE
LOAD_INDEX_INTO_CACHE
LOAD_LICENSE
LOCATION_UTILS_LIST
LOCATION_UTILS

MODIFY_TENANT
MIGRATE_UNIT
MERGE_RESOURCE_POOL
MODULE_DATA

OPTIMIZE_TABLE
OPTIMIZE_TENANT
OPTIMIZE_ALL
OLAP_ASYNC_JOB_SUBMIT
OLAP_ASYNC_JOB_CANCEL

PREPARE
PRINT_ROOT_TABLE
PURGE_RECYCLEBIN
PURGE_TENANT
PURGE_DATABASE
PURGE_TABLE
PURGE_INDEX
PHYSICAL_RESTORE_TENANT
PHYSICAL_RESTORE_STANDBY_TENANT

RENAME_USER
REVOKE
REPORT_REPLICA
RESTORE_TENANT_2
REFRESH_SCHEMA
RECYCLE_REPLICA
RENAME_TABLE
RELOAD_GTS
RELOAD_UNIT
RELOAD_SERVER
RELOAD_ZONE
RUN_JOB
REMOVE_CLUSTER
ROLLBACK_SAVEPOINT
RELEASE_SAVEPOINT
REFRESH_MEMORY_STAT
REVOKE_ROLE
REFRESH_IO_CALIBRATION
RECOVER
REMOVE_ARBITRATION_SERVICE
REPLACE_ARBITRATION_SERVICE
RECOVER_TABLE
REPAIR_TABLE
REDIS
REVOKE_PROXY
REBUILD_TABLET
REPLACE_TENANT

SPLIT_RESOURCE_POOL
SHOW_TABLES
SHOW_DATABASES
SHOW_COLUMNS
SHOW_VARIABLES
SHOW_TABLE_STATUS
SHOW_SCHEMA
SHOW_CREATE_DATABASE
SHOW_CREATE_TABLE
SHOW_CREATE_VIEW
SHOW_CREATE_PROCEDURE
SHOW_CREATE_FUNCTION
SHOW_PARAMETERS
SHOW_SERVER_STATUS
SHOW_INDEXES
SHOW_WARNINGS
SHOW_ERRORS
SHOW_PROCESSLIST
SHOW_CHARSET
SHOW_COLLATION
SHOW_TABLEGROUPS
SHOW_STATUS
SHOW_TENANT
SHOW_CREATE_TENANT
SHOW_TRACE
SHOW_ENGINES
SHOW_PRIVILEGES
SHOW_PROCEDURE_STATUS
SHOW_FUNCTION_STATUS
SHOW_GRANTS
SET_PASSWORD
START_TRANS
SWITCH_MASTER
SERVER_ACTION
SWITCH_ROOTSERVER
SWITCH_UPDATESERVER
SWITCH_REPLICA_ROLE
SET_NAMES
SWITCH_RS_ROLE
SHOW_RECYCLEBIN
SET_DISK_VALID
SHOW_CREATE_TABLEGROUP
STMT_TYPE_MAX
SET_TABLE_COMMENT
SET_COLUMN_COMMENT
SWITCHOVER
SET_ROLE
SYSTEM_GRANT
SYSTEM_REVOKE
SHOW_TRIGGERS
SHOW_CREATE_TRIGGER
SHOW_QUERY_RESPONSE_TIME
SHOW_PROFILE
SHOW_RESTORE_PREVIEW
SET_REGION_NETWORK_BANDWIDTH
SHOW_SEQUENCES
SHOW_PROCEDURE_CODE
SHOW_FUNCTION_CODE
SHOW_CREATE_USER
SHOW_PLUGINS
SHOW_ENGINE
SHOW_OPEN_TABLES
SERVICE_NAME
SHOW_CHECK_TABLE
SHOW_OLAP_ASYNC_JOB_STATUS
SET_CATALOG
SHOW_CATALOGS
SHOW_CREATE_CATALOG
SYS_DISPATCH_CALL
SHOW_LOCATIONS
SHOW_CREATE_LOCATION
SHOW_SENSITIVE_RULES
SET_PROTECTION_MODE

TABLET_CMD
TRUNCATE_TABLE
TABLE_TTL
TRANSFER_PARTITION
TRIGGER_STORAGE_CACHE

USE_DATABASE
UPGRADE_VIRTUAL_SCHEMA
USER_PROFILE
UNINSTALL_PLUGIN

VARIABLE_SET

WASH_MEMORY_FRAGMENTATION

XA_START
XA_END
XA_PREPARE
XA_COMMIT
XA_ROLLBACK
XA_RECOVER