title: R Multiline statement when using RSQLite
body: <p>I am having a transaction that needs to run on sqlite. The Transaction includes several queries. If built separately (line by line) it works but it requires the call of dbSendQuery n-times. It slows down the code quite a bit.</p>
  
  <p>The ideal code should look like this, but multiline query fails:</p>
  
  <pre><code>library("RSQLite")
  con &lt;- dbConnect(RSQLite::SQLite(), dbname="test.db")
  dbSendQuery(con, paste("CREATE TABLE Variables (Name TEXT PRIMARY KEY, RealValue REAL, IntegerValue INTEGER, BlobValue BLOB, TextValue TEXT)"))
  dbSendQuery(con, paste("INSERT INTO Variables (Name) VALUES ('newid');"))
  dbSendQuery(con,  paste("BEGIN IMMEDIATE TRANSACTION;",
                          "UPDATE Variables SET TextValue = '0' WHERE Name = 'newid';",
                          "UPDATE Variables SET RealValue = 0 WHERE Name = 'newid';",
                          "UPDATE Variables SET IntegerValue = 0 WHERE Name = 'newid';",
                          "COMMIT;",sep=" "))
  a &lt;- dbFetch(dbSendQuery(con, paste("SELECT * FROM _Variables;")))
  dbSendQuery(con, paste("COMMIT;"))
  </code></pre>