title: Is there any way to use OrmLite with Postgres hstores?
body: <p>We're currently using a PostgreSQL database and OrmLite. We now have a use case for using an <a href="http://www.postgresql.org/docs/9.0/static/hstore.html" rel="nofollow">Postgres hstore</a>, but can't find any way of accessing that table through OrmLite. I'd prefer to avoid opening a separate database connection just to select and insert to that one table, but I'm not seeing any other options.</p>
  
  <p>At the very least I'd like a handle to the existing connection OrmLite is using so I can reuse it to build a prepared statement, but I haven't found a way to get a <code>java.sql.Connection</code> starting from an OrmLite ConnectionSource<code>.
  </code>
  I see that OrmLite has a <code>JdbcCompiledStatement</code>, but that's just a wrapper around a <code>PreparedStatement</code> and requires the <code>PreparedStatement</code> to be passed in to the constructor. (Not sure what the use case for that is.)</p>
  
  <p>I've tried to use <code>DatabaseConnection.compileStatement(...)</code>, but that requires knowledge of the field types being used and OrmLite doesn't seem to know what an hstore is.</p>
  
  <p>I've tried to use <code>updateRaw()</code>, but that function only exists on an OrmLite dao that I don't have because the table I would link the dao to has a field type OrmLite doesn't recognize. Is there some way to get a generic dao to issue raw queries?</p>
  
  <p>I get that hstores are database specific and probably won't be supported by OrmLite, but I'd really like to find a way to transfer data to and from the database using unsupported fields instead of just unsupported queries.</p>