title: List of tables, db schema, dump etc using the Python sqlite3 API
body: <p>For some reason I can't find a way to get the equivalents of sqlite's interactive shell commands:</p>
  
  <pre><code>.tables
  .dump
  </code></pre>
  
  <p>using the Python sqlite3 API. </p>
  
  <p>Is there anything like that?</p>