go-sqlite3 feature: Allow custom window functions to be registered with the driver

This implements the registration of user-defined window functions. It extends the existing RegisterAggregator interface to allow the impl to implement Inverse and Value, in which case, the aggregator can be used both as a regular aggregate function and a window function.

Closes #1215

Feb 11 '24 01:02 ohaibbq

Hi @mattn, how can I help in getting this merged?

Mar 11 '24 02:03 ohaibbq

Sorry my delay. I'll look into it in later.

Mar 15 '24 16:03 mattn

Look good for me. @rittneje any opinion?

Mar 15 '24 16:03 mattn

A friendly bump on this @rittneje

Mar 28 '24 21:03 ohaibbq

@mattn This would be very helpful to get in for the users of https://github.com/goccy/bigquery-emulator I cannot merge my feature branch into the project as it uses a forked go-sqlite3.

Is there anything else I could do to push this along?

Apr 11 '24 01:04 ohaibbq

Yes, I'm thinking this is useful but I want to wait @rittneje 's opinion.

Apr 11 '24 02:04 mattn