title: How to set sqlt_datatype at SQL::Abstract/DBIx::Class?
body: <p>I can not write this condition: <code>app_period =&gt; { '@&gt;' =&gt; '2021-03-15' }</code> because I get an error:</p>
  <pre><code>malformed range literal: &quot;2021-03-15&quot;
  </code></pre>
  <p>Here how my query looks:</p>
  <pre><code>-&gt;search( $cond, @_ )-&gt;as_query
    \[
        (SELECT &quot;me&quot;.&quot;id&quot;, &quot;me&quot;.&quot;order_id&quot;, &quot;me&quot;.&quot;resource_type_id&quot;, &quot;me&quot;.&quot;service_type_id&quot;, &quot;me&quot;.&quot;amount&quot;, &quot;me&quot;.&quot;allocated_resource_id&quot;, &quot;me&quot;.&quot;last_used&quot;, &quot;me&quot;.&quot;app_period&quot;, &quot;me&quot;.&quot;sort_order&quot; FROM &quot;order_detail&quot; &quot;me&quot; WHERE ( ( &quot;app_period&quot; @&gt; ? AND &quot;order_id&quot; = ? ) )),
        [
          {
            dbic_colname =&gt; app_period,
            sqlt_datatype =&gt; tstzrange,
          },
          2021-03-15,
        ],
        [
          {
            dbic_colname =&gt; order_id,
            sqlt_datatype =&gt; integer,
          },
          11961,
        ],
      ]
  </code></pre>
  <p>I have found <a href="https://metacpan.org/pod/DBIx::Class::ResultSet#DBIC-BIND-VALUES" rel="nofollow noreferrer">this documentaion</a> and tried:</p>
  <pre><code>{ app_period =&gt; { '@&gt;' =&gt; [ \'timestamptz' =&gt; '2021-03-15' ] } }
  </code></pre>
  <p>But got error: <code>column &quot;timestamptz&quot; does not exist</code></p>
  <p>How to set correct <code>sqlt_datatype</code> for bind value?</p>