Added Two New Functions: Sigmoid and Tanh (that Are Useful for Machine Learning Applications)

Why it matters

These functions provide essential activation operations commonly used in machine learning workflows, enabling users to perform neural network type calculations directly within ClickHouse queries.

How to use it

Use the new functions sigmoid(x) and tanh(x) in your SQL queries to compute the sigmoid and hyperbolic tangent of numeric expressions respectively. For example:

SELECT sigmoid(value), tanh(value) FROM table_name;