BigQuery Storage Read API claims to support filters and simple projections pushed down to the storage:
https://cloud.google.com/bigquery/docs/reference/storage. See also this recent paper:
https://research.google/pubs/biglake-bigquerys-evolution-tow...I've also recently proposed a Table Read protocol that should be a "non-vendor-controlled" equivalent of BigQuery Storage APIs: https://engineeringideas.substack.com/p/table-transfer-proto...