they already have https://aws.amazon.com/redshift/features/aqua/
basically distributing compute down to the actual storage nodes
basically distributing compute down to the actual storage nodes
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.