
https://www.bradapp.com/docs/rec/stretching/ is (I think) an evolution of the "old" rec.stretching FAQ which was pretty good way back.
https://www.amazon.ca/Stretching-Scientifically-Guide-Flexib...
These are relatively old resources but worth reading and then updating.
At the risk of being harsh to the author, everything he knew about stretching was wrong ;)
http://www.amazon.co.uk/Stretching-Scientifically-Guide-Flex...
also re: Yoga ... there's lots of Yoga practices that combine strength with flexibility... Yoga tends to pop up as something that has been proven to be beneficial for back pain while pretty much everything else is as good as placebo (including surgical intervention).
People that sit all day tend to have shorter hamstrings (because the muscle is contracted all day) so I think stretching is important. An imbalance in leg muscles can tilt your pelvis and propagate up to your back...
Another thought, as someone who sits all day (really need a standing desk!) and practices Karate and a little Yoga I definitely recommend that people who sit all day do some sort of stretching and other activities to counteract the effects of prolonged sitting...