@mikeal I was listening to you on your youtube weekly catch-up. Was very interested in what you were doing with SQL and the battle between concurrency and streaming.
Have you considered a combo?
Index Tables with Stream Chunk Retrieval? As you navigate you can continue to stream.
Basically a variable entry point into your IPLD tables.
Bonus, you will be able to run prestatistics prior to retrieval for truly cost-based tuned optimized Queries.