Enable caching deterministic scripted queries in shard request cache

[stu-elastic]

Related: #49321

Right now, there is no way to know if scripts are deterministic or not. To ensure correctness, these scripts skip the shard request cache.

Painless scripts are deterministic if they only use deterministic APIs, eg not randomUUID. We'll have to evaluate other languages.

If a script is deterministic, it's results are cachable.

[elasticmachine]

Pinging @elastic/es-core-infra (:Core/Infra/Scripting)