I think you are talking about HTAP(https://en.wikipedia.org/wiki/Hybrid_transactional/analytical_processing https://en.wikipedia.org/wiki/Hybrid_transactional/a

I think you are talking about HTAP(https://en.wikipedia.org/wiki/Hybrid_transactional/analytical_processing https://en.wikipedia.org/wiki/Hybrid_transactional/analytica...). There are already decent products on the market. But don't expect 100% analytical capabilities like BigQuery / Snowflake. There are tradeoffs. If your workload fits the model well (mostly OLTP, but occasionally some with heavier aggregations, etc.), it would be awesome. Example: TiDB https://docs.pingcap.com/tidb/dev/explore-htap https://docs.pingcap.com/tidb/dev/explore-htap https://www.vldb.org/pvldb/vol13/p3072-huang.pdf https://www.vldb.org/pvldb/vol13/p3072-huang.pdf