support/configuration for SQLite3's `generate_series`

[malcook]

What would it take so enable/support/configure RSQLite to allow using generate_series (see The generate_series Table-Valued Function)

Trying after remotes::install_github("r-dbi/RSQLite#273") results as follows:

dbExecute(db,'SELECT value FROM generate_series(5,100,5)')
Error in result_create(conn@ptr, statement) : 
  no such table: generate_series
In addition: Warning message:
Closing open result set, pending rows 

It was suggested to me that requesting this is the key to: enabling SQLite's generate_sequence to be used in R's sqldf library under MS windows

Presumably an approach is similar to #266 only with this source...???

[krlmlr]

I'm supportive of adding more extensions, but I'd like to streamline the process of including and updating them. Ideally, the data-raw/upgrade script would extract the relevant files from the sqlite-src-*.zip file and store them. These files should then be used unchanged for compilation. Documentation at https://www.sqlite.org/loadext.html can help.

Would you like to take a stab?

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.