title: SQLAlchemy query raises unnecessary warning about sqlite and Decimal, how to specifically disable?
body: <p>I'm using SQLAlchemy via pyramid accessing a simple sqlite database.</p>
  
  <p>As I was building my progressively more complex queries, I got this warning:-</p>
  
  <p>SAWarning: Dialect sqlite+pysqlite does <em>not</em> support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.</p>
  
  <p>One of my queries does this (paraphrasing):-</p>
  
  <pre><code>session.query(subquery.c.a*100.0/(subquery.c.b+subquery.c.c))
  </code></pre>
  
  <p>In this case, subquery is the name of a subquery, and a, b, and c are integers.</p>
  
  <p>I'm not saving the result of the query or running any commits, this is purely data extraction/querying, hence I was surprised when the warning above was raised. How do I ignore this warning without filtering it out totally (in case in future I do accidentally save Decimal data to the database)?</p>