title: Error : {"message":"sqlite3_prepare_v2 failure: near \"id\": syntax error","code":5}
body: <p>I have a object below and i want to save it to a sqlite database but I kept getting the error. below is the snippet of the object that I want to save. I already used JSON.Stringify but still i cant get the correct answer.</p>
  
  <pre><code>[{"id":0,"inputName":"Seeds","cost":"100"},
  {"id":2,"inputName":"Chemicals(Insecticide,Pesticide,Fungicide)","cost":"100"},
  {"id":0,"inputName":"ASample","cost":"100"}]
  </code></pre>
  
  <p>Here is my sample insert query code</p>
  
  <pre><code>    this.storeInput = JSON.stringify(this.input);
      this.storeLabor = JSON.stringify(this.labor);
      this.storeAdmin = JSON.stringify(this.admin);
      this.sqlite.create({
        name: 'ionicdb.db',
        location: 'default'
          }).then((db: SQLiteObject) =&gt; {
            db.executeSql('INSERT INTO `carrots_expenses`(`input`, `labor`, `admin`) VALUES("'+this.storeInput+'","'+this.storeLabor+'","'+this.storeAdmin+'")', {})
  
              }).catch(e =&gt; console.log(JSON.stringify(e)))
  </code></pre>
  
  <p>This is how I created the table</p>
  
  <pre><code>db.executeSql('CREATE TABLE IF NOT EXISTS carrots_expenses(`rowid` int auto_increment primary key, `input` JSON DEFAULT NULL, `labor` JSON DEFAULT NULL, `admin` JSON DEFAULT NULL)', {})
  </code></pre>
  
  <p>I spend too much time searching for the answer and I can`t find it, I might miss keywords to search for something.</p>