The functionality for streaming queries was added before.
Go bindings author's quote:
in my use case it reduced the RSS of my application by 20% and the GC pressure of about 35%
The task is to check their PR chdb-io/chdb-go#32
And prepare optimizations that could work for D
For testing the data should be big enough