These guys seem to think relational databases are a valid alternative in the process automation world, and seem to have made a successful business around the idea:
https://inductiveautomation.com/news/process-historians-vs-s...
[I have no data on how well their product performs in practice]