-- Extract simple value
JSON_EXTRACT(column_name, '$.field_name')

-- Remove quotes from extracted string
REPLACE(JSON_EXTRACT(column_name, '$.field_name'), '"', '')

-- Handle null values
CASE 
  WHEN JSON_EXTRACT(column_name, '$.field_name') IS NOT NULL 
  THEN REPLACE(JSON_EXTRACT(column_name, '$.field_name'), '"', '')
  ELSE 'default_value'
END

-- Extract nested value
JSON_EXTRACT(column_name, '$.parent.child')

-- Extract array element
JSON_EXTRACT(column_name, '$.array[0]')

-- Extract multiple values
CONCAT(
  REPLACE(JSON_EXTRACT(column_name, '$.field1'), '"', ''),
  ' - ',
  REPLACE(JSON_EXTRACT(column_name, '$.field2'), '"', '')
)

-- Extract domain from URL
REGEXP_EXTRACT(url_field, '^(?:https?:\/\/)?(?:[^@\n]+@)?(?:www\.)?([^:\/\n?]+)')

-- Get URL path
REGEXP_EXTRACT(url_field, '^(?:https?:\/\/)?(?:[^@\n]+@)?(?:www\.)?[^:\/\n?]+(?::\d+)?(/[^?#]+)')

-- Remove special characters
REGEXP_REPLACE(field_name, '[^a-zA-Z0-9]', '')

-- Format phone numbers
REGEXP_REPLACE(phone_field, '([0-9]{3})([0-9]{3})([0-9]{4})', '($1) $2-$3')

-- Check email format
CASE 
  WHEN REGEXP_MATCH(email_field, '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$')
  THEN 'Valid'
  ELSE 'Invalid'
END

-- Extract week number
WEEK(date_field)

-- Format date
DATE_FORMAT(date_field, '%Y-%m-%d')

-- Calculate date difference
DATEDIFF(end_date, start_date)

-- Percentage calculation
(value / total) * 100

-- Running total
SUM(value) OVER (ORDER BY date_field)

-- Moving average
AVG(value) OVER (ORDER BY date_field ROWS BETWEEN 6 PRECEDING AND CURRENT ROW)

-- Concatenate fields
CONCAT(first_name, ' ', last_name)

-- Case transformation
CASE 
  WHEN value > 100 THEN 'High'
  WHEN value > 50 THEN 'Medium'
  ELSE 'Low'
END

-- Instead of nested JSON
CASE 
  WHEN JSON_EXTRACT(data, '$.complex.nested.field') IS NOT NULL 
  THEN REPLACE(JSON_EXTRACT(data, '$.complex.nested.field'), '"', '')
  ELSE 'default'
END

-- Create intermediate fields
WITH extracted_field AS (
  SELECT REPLACE(JSON_EXTRACT(data, '$.complex.nested.field'), '"', '') as field
)

-- Convert string to number
CAST(string_field AS DECIMAL)

-- Convert number to string
CAST(number_field AS CHAR)

-- Handle null values
COALESCE(field_name, default_value)

-- Divide by zero prevention
CASE 
  WHEN denominator = 0 THEN 0 
  ELSE numerator / denominator 
END

-- Null handling in calculations
COALESCE(value1 + value2, 0)