Comment by fifilura

Declarative languages are fantastic to reason about code.

But the true power is unlocked once the underlying libraries are implemented in a way that surpassesthe performance that a human can achieve.

Since implementation details are hidden, caches and parallelism can be added without the programmer noticing anything else than a performance increase.

This is why SQL has received a boost the last decade with massively parallel implementations such as BigQuery, Trino and to some extent DuckDB. And what about adding a CUDA backend?

But all this comes at a cost and needs to be planned so it is only used when needed.