PR #100773 - sql: add `unbounded_parallel_scans` session variable

[cockroach-teamcity]

Exalate commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/100773 Commit: https://github.com/cockroachdb/cockroach/commit/caff563321b7f28cadac6b45450a34ca0423ccb5 Epic: CRDB-25448

---

Release note (sql change): New session variable unbounded_parallel_scans has been introduced which controls whether scans will be parallelized across ranges in more cases. Note that using this feature can lead to increased likelihood of OOMs, so it should be used with care (namely when you expect that the scan should read "reasonable" number of rows - probably less than 10k). Also note that queries with LIMITs aren't affected by this variable - cross-range parallelism of scans continues to be disabled for those.

Jira Issue: DOC-7417