[classshot]

Solid points. Nowadays, many teams also look into HTAP solutions or using logical replication (CDC) to pipe transactional data from an RDBMS into a columnar data warehouse. That way, you avoid overloading production OLTP systems while getting the best query performance for BI and reporting.