title: Is rank function supported in python sqlite3
body: <p>I'm wondering if <code>python</code> <code>sqlite3</code> library supports RANK() function.</p>
  
  <p>When I execute a query via online <code>Sqlite</code> Browser it works fine, but via <code>python</code> it fails.</p>
  
  <pre><code>File "xyz.py", line 509, in createData
      conn.execute('SELECT RANK() OVER ( ORDER BY dateAndTime)  FROM xyz;')
  sqlite3.OperationalError: near "(": syntax error
  </code></pre>
  
  <p>Thanks in advance!</p>