I think you are talking about HTAP(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