Improve caching options (e.g. disabling to allow consistent side-effects)

### OS/platform

Linux

### Emacs version and provenance

Emacs 29.2, compiled from scratch

### Org version and provenance

9.6.15, bundled with Emacs

### org-ql package version and provenance

v0.8.5 (shipped with doom-emacs)

### Description

RANT: It's not really obvious that org-ql-select `:action` gets cached by org-ql and IMHO `:action` is a bit a misleading name for a function that is supposed to be pure, `:map` would have been a better choice.

FEATURE REQUEST: it would be great to have a parameter to avoid the `:action` being cached, without having to empty the whole cache.

### Etc.

_No response_