title: SQL statements must be issued with dbExecute() or dbSendStatement() instead of dbGetQuery() or dbSendQuery()
body: <p>I would like to create a new database, which returns the results of a query as a dataframe. If I use <code>dbExecute()</code> or <code>dbSendStatement()</code>, as indicated in the warning message, it won't return the required dataframe. What can I do to remove this warning? Why am I getting these warnings?</p>
  <pre><code>drv &lt;- RSQLite::dbDriver(&quot;SQLite&quot;)
  con &lt;- DBI::dbConnect(drv, dbname= tempfile())
  DBI::dbGetQuery(con, paste(&quot;CREATE TABLE activity&quot;,
          &quot;(aid INTEGER, cid INTEGER,&quot;,
          &quot;activity INTEGER, score REAL)&quot;))
  # data frame with 0 columns and 0 rows
  # Warning message:
  # In result_fetch(res@ptr, n = n) :
  #  SQL statements must be issued with dbExecute() or dbSendStatement() instead of dbGetQuery() or dbSendQuery().
  </code></pre>
  <p>Thank you very much! :)</p>