It's something of a misconception that an RDBMS should be used for transactional workloads.
RDBMSs are table stores; in a sense if anything that's a model better suited for analytical than transactional not that that's really a fair conclusion either
We do use a RDBMS as well but mostly for the transactional part and we get away with just using simple SQL, no join and complex stuff.