rich_swift_5881

Convert product names to URL-friendly slugs by replacing spaces with underscores and converting to l

From api_calls, return call_id, endpoint, and STRPOS(SUBSTR(endpoint, 2), '/') AS next_slash for row

From api_calls, return call_id and REPLACE(endpoint, '/api/', '/') AS short_path

From api_calls, return call_id and SUBSTR(endpoint, 1, 8) AS prefix for rows where endpoint LIKE '/a

Remove the leading 'v' prefix from version numbers in deploy_logs using LTRIM

Normalize API endpoints by removing any trailing '/' characters using RTRIM

Extract the service type before the first hyphen

Find the position of the first hyphen in each service name using STRPOS

Replace all hyphens with spaces in server_name

Extract the last 3 characters from each version string as version_suffix from the deploy_logs table