v.23.12New Feature
Added SQL Function to Generate Sqids
Added a new SQL functionsqidto generate Sqids (https://sqids.org/), example:SELECT sqid(125, 126). #57512 (Robert Schulze).
Why it matters
The feature provides a way to create compact and human-friendly identifiers for use in URLs or other contexts where short unique strings are preferred over numeric IDs. It helps users by enabling easy generation of Sqids directly within ClickHouse queries, avoiding the need for external libraries or additional processing.How to use it
Use thesqid function in your SQL queries by passing one or more integer values as parameters, for example:SELECT sqid(125, 126)This will return a Sqid generated from the given input values.