Add support for streaming queries to the .select() shortcut

[codetheweb]

I'm mapping over a very large table and so am using cursors (currently via pg-query-stream).

The SQL statement generated by the .select() shortcut doesn't work for streaming because jsonb_agg(...) is used to gather the result. I took a quick look at the code but it seems like it could be rather complicated to add cursor/streaming support, either to .select() or in general to SQLFragment<>.

Is this something you'd be interested in Zapatos supporting? If so, do you have any tips for implementation? Happy to take a crack at this.

[jawj]

Hi Max. This is a nice idea, though not sure exactly what the API ought to be. I'll try to have a look at it in the next few days. Would be great if you're then happy to have a go at it!

[vitaly-t]

Check out pg-iterator ;)