title: How create table with all days of year using a start_date variable?
body: <p>I'd like to create a table with all the days of a year using HQL.
  I already tried this approach :</p>
  
  <p><a href="https://stackoverflow.com/questions/2157282/generate-days-from-date-range">generate days from date range</a></p>
  
  <p>but the hql is a bit different from sql
  What's the best approach? <br/>
  Using the PL/HQL or using bash script and importing ?</p>
  
  <p>Expected result:</p>
  
  <pre><code>start_date = 2017-02-14;
  
  | date     |
  |2017-02-14|
  |2017-02-13|
  |2017-02-12|
  |2017-02-11|
  |2017-02-10|
  |2017-02-09|
  |2017-02-08|
  |2017-02-07|
  ....
  </code></pre>
  
  <p>Thanks</p>