v.22.11Improvement

Add PowerBI Compatibility Functions for MySQL Protocol

Add some functions for compatibility with PowerBI, when it connects using MySQL protocol #42612 (Filatenkov Artur).
Added several functions to improve compatibility with PowerBI when connecting to ClickHouse using the MySQL protocol.

Why it matters

PowerBI users connecting to ClickHouse via the MySQL protocol previously faced compatibility issues due to missing functions expected by PowerBI. This feature introduces those functions to ensure smoother integration and better interoperability between ClickHouse and PowerBI.

How to use it

Users can benefit from this feature simply by connecting PowerBI to ClickHouse through the MySQL protocol. The added functions work transparently to improve compatibility and require no additional configuration.