title: Get list of dates from two dates columns in sqlite3 (pandasql)
body: <p>I have a <code>date_from</code> and <code>date_to</code> . I want to get the list of dates in between these two dates, grouped by version.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>version</th>
  <th>date_from</th>
  <th>date_to</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ver1</td>
  <td>2020-01-05</td>
  <td>2020-01-07</td>
  </tr>
  <tr>
  <td>ver2</td>
  <td>2021-05-09</td>
  <td>2021-05-11</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2022-02-05</td>
  <td>2022-02-07</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Result I want</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>version</th>
  <th>date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>ver1</td>
  <td>2020-01-05</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2020-01-06</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2020-01-07</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2022-02-05</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2022-02-06</td>
  </tr>
  <tr>
  <td>ver1</td>
  <td>2022-02-07</td>
  </tr>
  <tr>
  <td>ver2</td>
  <td>2021-05-09</td>
  </tr>
  <tr>
  <td>ver2</td>
  <td>2021-05-10</td>
  </tr>
  <tr>
  <td>ver2</td>
  <td>2021-05-11</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried that recursive query but it didn't work properly :(</p>
  <pre><code>WITH RECURSIVE dates(Date) AS
     (
         SELECT date_from from df as Date
         UNION ALL
         SELECT date(date, '+1 day') FROM dates WHERE Date &lt; (Select date_to from df)
     )
     SELECT DATE(Date) FROM dates; 
  </code></pre>