title: How to solve H2 database `Values of types "BOOLEAN" and "INTEGER" are not comparable` syntax error?
body: <p>I have an H2 column of type Boolean but Hibernate query it using a <code>1</code>/<code>0</code> instead of <code>TRUE</code>/<code>FALSE</code> values, which leads to the <code>Values of types &quot;BOOLEAN&quot; and &quot;INTEGER&quot; are not comparable</code> syntax error.</p>
  <p>For instance, Hibernate 5 will write</p>
  <pre class="lang-sql prettyprint-override"><code>WHERE myBooleanColumn = 1
  </code></pre>
  <p>instead of</p>
  <pre class="lang-sql prettyprint-override"><code>WHERE myBooleanColumn = TRUE
  </code></pre>
  <p>How can this be solved?</p>
  <p>My H2 database version is  2.0.206 and I'm using Spring Boot 2.5.6.</p>