String and Date Manipulation AI Prompt

Write SQL for these string parsing and date calculation tasks.

Tasks: {{tasks}}
Database: {{database}}

1. String functions:
   CONCAT / ||: concatenate strings
   SUBSTRING(text, start, length): extract substring
   REGEXP_REPLACE(text, pattern, replacement): replace with regex
   SPLIT_PART(text, delimiter, part): split and extract nth part
   TRIM / LTRIM / RTRIM: remove whitespace or characters
   LOWER / UPPER: normalize case
   REGEXP_MATCHES: extract all regex captures

   Email domain extraction:
   SPLIT_PART(email, '@', 2) AS email_domain

   Normalize phone number:
   REGEXP_REPLACE(phone, '[^0-9]', '', 'g') AS clean_phone

2. Date functions:
   DATE_TRUNC('month', timestamp): truncate to month start
   DATE_PART('year', timestamp): extract year
   EXTRACT(DOW FROM timestamp): day of week (0=Sunday)
   CURRENT_DATE, NOW()

   Days between two dates:
   (end_date::date - start_date::date) AS days_elapsed

   First day of next month:
   DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 month'

   Age in complete years:
   DATE_PART('year', AGE(birth_date)) AS age_years

3. Interval arithmetic:
   created_at + INTERVAL '30 days' AS trial_end
   WHERE event_date BETWEEN CURRENT_DATE - INTERVAL '7 days' AND CURRENT_DATE

4. Time zone handling:
   event_timestamp AT TIME ZONE 'UTC' AT TIME ZONE 'America/New_York' AS local_time
   -- Always store timestamps in UTC; convert on display only

5. JSON extraction (PostgreSQL):
   properties->>'user_id' AS user_id             -- text extraction
   (properties->>'amount')::NUMERIC AS amount     -- cast to numeric
   properties @> '{"plan": "premium"}'            -- containment check
   JSONB_ARRAY_ELEMENTS(properties->'items')       -- expand array

Return: SQL for each transformation task with inline comments explaining the function used.