v.25.12New Feature

Add HMAC(algorithm, message, key) sql

Add HMAC(algorithm, message, key) sql function as a part of #73900 and #38775. #90837 (Mikhail f. Shiryaev).
Introduces the HMAC(algorithm, message, key) SQL function in ClickHouse to compute Hash-based Message Authentication Codes using various algorithms.

Why it matters

This feature adds support for generating HMACs directly within ClickHouse queries, enabling secure message authentication and integrity verification. It simplifies workflows by allowing cryptographic operations inside SQL without external processing.

How to use it

Use the HMAC function in SQL queries with three parameters: the hashing algorithm name (e.g., 'SHA256'), the message string, and the secret key. For example:

SELECT HMAC('SHA256', 'message', 'secret_key') AS hmac_value;