Or something like REGEXP_EXTRACT.  Also complex nested logical statements is something used very often in the creation of custom channels for traffic.This is a fairly typical requirement of most semi-advanced web analytics, but I imagine Adobe is avoiding it to not bear compute costs for users.

It sure would be nice to know why this is how the 'data warehouse platform operates'.  A data warehouse should be able to process hit-level requests, but it looks like Adobe's ideas of those capabilities are limited to some kind of summary level.