title: How can I create range of date given the start date and end date
body: <p>I am using sqldf library to manipulate data frame in R. Currently, I have a data frame like this:</p>
  <pre><code>ID       Start_Date       End_Date
  1          08-29           09-01
  </code></pre>
  <p>I want to create a new data frame using sqldf to create a range of dates between the Start_Date and the End_Date, for example, for ID1, I want the final data frame look like:</p>
  <pre><code>ID        Date_Range      
  1           08-29   
  1           08-30   
  1           08-31
  1           09-01
  </code></pre>
  <p>I think I can just create a new data frame. But I am wondering if it is possible to implement in sqldf?</p>