title: How to fix ValueError: parameters are of unsupported type python
body: <p>I am trying to parameterize my query in order to be able to add in title with ' in the full world , for example "Can't log in". I did some reading and realised i have to paramterize my query. So far my query before was as follows :</p>
  
  <pre><code>def create_issue(self, title, description):
          cursor = self._conn.cursor()
          try:
              cursor.execute(
                  """INSERT INTO issues(
                      title,
                      description
                  ) VALUES('{}', '{}')""".format(title, description))
              cursor.execute("select last_insert_rowid()")
              return cursor.fetchone()[0]
          finally:
              cursor.close()
  </code></pre>
  
  <p>I have tried to paramterize this query in order for it to accept ' as part of the string and not throw up a OperationalError. I have tried the following below: </p>
  
  <pre><code>def create_issue(self, title, description):
          cursor = self._conn.cursor()
          try:
  
  
              cursor.execute("INSERT INTO issues (title, description) VALUES (?,?)", {title, description})
              cursor.execute("select last_insert_rowid()")
              return cursor.fetchone()[0]
          finally:
              cursor.close()
  </code></pre>
  
  <p>I get the following error : </p>
  
  <blockquote>
    <p>cursor.execute("INSERT INTO issues (title, description) VALUES
    (?,?)", {title, description}) ValueError: parameters are of
    unsupported type</p>
  </blockquote>
  
  <p>What is it that i am doing wrong and how can i get my query to work </p>
  
  <pre><code>My table properties are as follows:
  CREATE TABLE issues(
    id INTEGER PRIMARY KEY,
    title VARCHAR(255),
    description VARCHAR(255),
    opened_datetime CHAR(26) DEFAULT (datetime('now')),
    closed_datetime CHAR(26) DEFAULT (datetime('now'))
  )
  </code></pre>
  
  <p>I am passing in the text box title the following input "Can't log in "
  In the description i am passing in the following input " User dev cannot log in "</p>