Transfers: introduce source selection strategies. Closes #5776 #3090

Job	Run time
Check Python Type Annotations	31s
Add header lint	6s
Python type check (Pyright)	3m 51s
release-patch-setup	0s
setup	8s
release-patch-test	0s
test (alma9, 3.9, autotest, syntax, 1, false)	21m 28s
test (alma9, 3.9, autotest, docs, false)	4m 45s
test (alma9, 3.9, autotest, client_syntax, false)	4m 36s
test (alma9, 3.9, autotest, client, postgres14)	8m 44s
test (alma9, 3.9, autotest, remote_dbs, oracle, influxdb_elastic)	37m 42s
test (alma9, 3.9, autotest, remote_dbs, mysql8, influxdb_elastic)	39m 53s
test (alma9, 3.9, autotest, remote_dbs, postgres14, influxdb_elastic)	30m 54s
test (alma9, 3.9, autotest, sqlite, sqlite)	37m 18s
test (alma9, 3.9, autotest, multi_vo, postgres14, /opt/rucio/etc/multi_vo/tst)	39m 56s
test (alma9, 3.10, autotest, syntax, 1, false)	24m 45s
test (alma9, 3.10, autotest, client_syntax, false)	11m 49s
test (alma9, 3.10, autotest, client, postgres14)	13m 53s
test (alma9, 3.10, autotest, remote_dbs, oracle, influxdb_elastic)	40m 26s
test (alma9, 3.10, autotest, remote_dbs, mysql8, influxdb_elastic)	43m 5s
test (alma9, 3.10, autotest, remote_dbs, postgres14, influxdb_elastic)	38m 18s
test (alma9, 3.10, autotest, sqlite, sqlite)	34m 53s
test (alma9, 3.10, autotest, multi_vo, postgres14, /opt/rucio/etc/multi_vo/tst)	47m 19s
	8h 4m 20s

Provide feedback