It would be useful to be able to query time ranges for certain types of data.

[cryptobench]

While building the CoinMarketCap clone PoC using Golem Base, I ran into a limitation when working with time-series data like charts that show coin values over time.

It would be very useful to support querying for specific time ranges (e.g. from timestamp X to Y), so charts can fetch data for the last 7 days, 30 days, 6 months, and so on. Right now, the only option is to fetch all historical data, which is inefficient and can lead to errors like:

HttpRequestError: HTTP request failed.

Status: 500  
URL: https://kaolin.holesky.golem-base.io/rpc  
Request body: {"method":"golembase_queryEntities","params":["type=\"CoinHistoricalPrice\""]}

Details: {"code":-32020,"message":"backend response too large"}  
Version: viem@2.31.4

Adding support for time range filters would both improve performance and reduce the likelihood of hitting response size limits.

(Note: Even with time range filters, querying very large datasets could still trigger the above error, but that’s a separate issue.)

[krzysiekfonal]

This is - in the fact - very similar case to:
#24
so about introducing well known SQLs offsets and limits and yet together with offset and limits sorting comes (otherwise ranges doesn't make sense). So it is all related and requires to take significant architecture decisions and implementation on GolemBase side. We can open issue also there for tracking but it is, however, the issue we are discussing intensively right now.

However, this issue we can keep to remember to change it on SDK side as soon as GolemBase is ready.