title: Get total record count for SqlAlchemy query result, which uses pagination(limit, offset)
body: <p>I am using <code>sqlalchemy</code> query with <code>limit</code> and <code>offset.</code> Now I need to get the <code>total count</code> of the query result.</p>
  <p>For now I am using count query and limit query separately and getting the results. Is there any efficient way to get the count in a single sqlalchemy query.</p>
  <p>Here is the sample of currently what I am using,</p>
  <pre><code># getting total count
  docs_count = DB_SESSION.query(Documents).count()
  
  # using limit and offset
  docs_list = DB_SESSION.query(Documents).limit(10).offset(0)
  </code></pre>
  <p>Now is it possible to combine this into a single query, or there any efficient method to do this. Thanks all.</p>