jaip3r

Extract the service type before the first hyphen

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

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

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

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