Semantic Versioning UDF in ClickHouse

Embrace is an AI-driven mobile app observability solution provider based on OpenTelemetry (OTel). They use ClickHouse for time series analytics products. One of the key features they offer is sorting app versions according to semantic versioning rules, which are not supported by ClickHouse out of the box. To overcome this limitation, Embrace uses User-Defined Functions (UDFs) introduced in ClickHouse v21.10. They have created a UDF called `sortableSemVer` that converts semantic version strings into arrays of integers for sorting purposes. This function handles complex version strings and can be customized further to suit specific needs.