v.23.12New Feature

Added SQL Function to Generate Sqids

Added a new SQL function sqid to generate Sqids (https://sqids.org/), example: SELECT sqid(125, 126). #57512 (Robert Schulze).
Added a new SQL function sqid to generate Sqids, which are short, unique, and URL-friendly IDs.

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 the sqid 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.