Add log_comment setting for issue #18494

Why it matters

This feature allows users to include descriptive comments in query logs, enhancing traceability and debugging by providing context about queries directly within the logs.

How to use it

Set the log_comment parameter when executing queries or in the user/session settings to add custom comments. For example:

SET log_comment = 'My custom comment';
SELECT * FROM table;