I've not yet investigated AQUA, but it's absolutely on the list.

The idea that is handles some SQL functionality with additional parallelism seems fine, but then I read that if a query uses any AQUA functionality, it's something like the entire query runs in AQUA, and that seems to me to be potentially a problem.

I'm very curious to start investigating, but there's a list of higher priority matters to investigate.