title: Rails 5 active record query where date range overlaps with other date range
body: <p>I have a model with <code>planting_date_begin</code> and <code>planting_date_end</code>.  I want to retrieve all records where any date in <code>planting_date_begin..planting_date_end</code> overlap with the range for the <code>current_week</code></p>
  
  <p>example:
  if planting_date_begin: 3/5/2017 and planting_date_end: 3-12/2017
  and this week is 3/26/2017-4/1/2017 it is not included in query.  </p>
  
  <p>if <code>planting_date_begin</code>: 3/1/2017 and <code>planting_date_end</code>: 4/15/2017 it would be included.</p>
  
  <p>I set current_week range:</p>
  
  <pre><code>today = Date.today
  days_in_week = today.at_beginning_of_week..today.at_end_of_week
  </code></pre>
  
  <p>This syntax is not right but I want to do something like:</p>
  
  <pre><code>Planting.where((planting_date_begin..planting_date_end).overlaps?(days_in_week) )
  </code></pre>
  
  <p>What is a succinct way to handle this?  Incidentally, I am using postgres in case there is a way to do it differently.</p>