| AES_DECRYPT | Decrypts a string produced by AES encryption. Deprecated on Dremio Software: Will be removed from Dremio Software in a future release. Dremio recommends DECRYPT on Dremio Software for improved security and support for modern cipher modes. |
| AES_ENCRYPT | Encrypts a string using AES encryption. Deprecated on Dremio Software: Will be removed from Dremio Software in a future release. Dremio recommends ENCRYPT on Dremio Software for improved security and support for modern cipher modes. |
| DECRYPT | Decrypts data using AES decryption with various modes, including AES-ECB, AES-CBC, and AES-GCM. Supports PKCS7 padding or no padding options. For AES-GCM mode, verifies the authentication tag. |
| ENCRYPT | Encrypts data using AES encryption with various modes, including AES-ECB, AES-CBC, and AES-GCM. Supports PKCS7 padding or no padding options. |
| MD5 | Computes the MD5 hash value of a string. |
| SHA, SHA1 | Computes the SHA-1 hash value of a string. |
| SHA256 | Computes the 256-bit SHA-2 hash value of a string. |
| SHA512 | Computes the 512-bit SHA-2 hash value of a string. |