get_observations_as_timeseries not order in time

[peterdudfield]

I tried getting some gsp observation data, and I noticed that sometimes it wasnt return in time order

This was when I pulled the data from 2025-12-10 to 2025-12-14 for gsp_id 100. For observer pvlive_in_day

• TODO: check there is an order by in sql query.

If this is not possible, I can put the order by in the API

[devsjc]

I think it's in general good to assume things won't be ordered. I can (and probably will!) put ordering in, but if you start hardcoding logic in APIs with assumptions about positioning of things in an array, you're opening yourself up to silent bugs later on if that ever changes...