title: How to query overlapping dates on Postgres DateRange field
body: <p>I have a model with a PostgreSQL <code>DateRange</code> field:</p>
  <pre><code>class MyModel(models.Model):
      date_range = DateRangeField()
  </code></pre>
  <p>If I want to query this to see if another date overlaps, that's easy enough:</p>
  <pre><code>MyModel.objects.filter(date_range__overlap=other_date)
  </code></pre>
  <p>But if I have built a list of <code>DateRange</code> objects, how can I search the list asking this same thing of the list (rather than the queryset). I.e. &quot;Does this DateRange overlap with any of the DateRanges in this list?&quot;:</p>
  <pre><code>mylist = [DateRange([2021-10-04, 2021-10-05]), DateRange([2022-10-04, 2022-10-05])]
  
  for dr in mylist:
      dr.overlap(query_date) # fails
  </code></pre>
  <p>Note: <code>DateRange</code> objects have no attribute <code>overlap</code> per <a href="https://www.psycopg.org/docs/extras.html#range-data-types" rel="nofollow noreferrer">docs</a>.</p>