title: Filter on DATE within custom type?
body: <p>We have a custom type in our oracle db, let's call it stamp:</p>
  <pre><code>CREATE TYPE stamp AS OBJECT(
    timestamp DATE,
    count INTEGER
  )
  </code></pre>
  <p>I'm struggling with just selecting where stamp.timestamp is between certain dates, and I can't really find that use case in the oracle docs.</p>
  <p>I thought &quot;just use dot notation&quot;, which didn't work. I did solve that one by finding out I need to use an alias in this specific case, so this is my current state (column is called 'when'):</p>
  <pre><code>WHERE a.when.timestamp between TO_DATE('2021-06-07', 'YYYY-MM-DD') AND TO_DATE('2021-06-09', 'YYYY-MM-DD');
  </code></pre>
  <p>Except now it says <code>Unsupported column type</code>, which is not very helpful as both the column and entries in the table already exist.</p>
  <p>Any idea how to select on a nested date?</p>