title: How do I pull an extra row when pulling data from between dates?
body: <p>I'd like to pull another row with the nearest date before the beginning of the following query from a sqlite db:</p>
  
  <p><code>select * from inv WHERE TIME BETWEEN date1 AND date2</code></p>
  
  <p>Is there a simple addition to the query or do I need to pull in more data and do the transformation at the end?</p>
  
  <p>Thank you</p>