We are in the process of setting up a demo version of limesurvey, with a view to testing it out for use in our organisation to hold routine surveys. These surveys will always be open (collecting new responses daily). As such, analysts will not normally want to import all the data in one go as e.g. after one year there will be several thousand responses. More typically we would want to import a subset of the data that falls within a specific range for a given analysis pipeline.

It would therefore be useful to be able to perform a select SQL query for e.g., responses for a particular survey ID within a specific date range, or age range or whatever. I (and an increasing number of my colleagues) use R, and ultimately we want to be able to create automated reports from the survey data with R markdown which we might run on a regular basis (weekly / quarterly / annual etc).

Is it possible to perform an SQL select query with limer and if so would it be possible to demonstrate with a vignette how to do this?