tuned_query_with_variant.types.sql

WITH
   union_tab as (
      select username, 'daily_activity' as label, value from web.daily_activity UNION ALL
      select username, 'user_address' as label, value from web.user_attributes_1 UNION ALL
      select username, 'user_address' as label, value from web.user_attributes_1 UNION ALL
      select username, 'user_mobile' as label, value from web.user_attributes_2 UNION ALL
      select username, 'user_email_optin' as label, value from web.user_attributes_3 UNION ALL
      select username, 'user_mobile_optin' as label, value from web.user_attributes_4 UNION ALL
      (... and so on ...)
   )
 
SELECT username
   , "'daily_activity'".value:date               AS date
   , "'daily_activity'".value:hit_count          AS hit_count
   , "'user_address'".value:user_address         AS user_address
   , "'user_mobile'".value:user_mobile           AS user_mobile
   , "'user_email_optin'".value:user_email_optin AS user_email_optim
   , "'user_email_optin'".value:optin_date       AS user_email_optin_date
   , "'user_mobile_optin'".value:mobile          AS user_mobile_optin
   ( ... )
FROM union_tab
   PIVOT (
      MAX(value)
      FOR label IN (
         'daily_activity',
         'user_address',
         'user_mobile',
         'user_email_optin',
         'user_mobile_optin',
         ( ... )
      )
   )
WHERE date IS NOT NULL -- main left join table