v.22.4Improvement

Added is_secure column to system.query_log for secure connection indication

Added is_secure column to system.query_log which denotes if the client is using a secure connection over TCP or HTTP. #35705 (Antonio Andelic).
Added the is_secure column to the system.query_log table to indicate whether a client connection is secure over TCP or HTTP.

Why it matters

This feature helps users identify and audit queries executed over secure connections, enhancing security monitoring and compliance by distinguishing between secure and non-secure client connections.

How to use it

Query the system.query_log table and check the is_secure boolean column to determine if a query was executed using a secure connection over TCP or HTTP. No additional configuration is required.