What you're describing is targeted by Parquet/Iceberg + an engine like Dremio. But targeted at big data / analytics.