But what if we are using columnar database designed for warehouses and analytics purposes such Bigquery they already optimized for high reads.

Plus we can user nested records of such databases to store data in one table?