title: Python-Sqlalchemy Binary Column Type HEX() and UNHEX()
body: <p>I'm attempting to learn Sqlalchemy and utilize an ORM. One of my columns stores file hashes as binary. In SQL, the select would simply be </p>
  
  <p><code>SELECT type, column FROM table WHERE hash = UNHEX('somehash')</code></p>
  
  <p>How do I achieve a select like this (ideally with an insert example, too) using my ORM? I've begun reading about column overrides, but I'm confused/not certain that that's really what I'm after.</p>
  
  <p>eg
  <code>res = session.query.filter(Model.hash == __something__? )</code></p>
  
  <p>Thoughts?</p>