title: Rename column in sqlite
body: <p>I would like to rename a column in sqlite.  I created two word titles with whitespace for some columns which creates issues later on (e.g. <code>first name</code> instead of <code>first_name</code>.</p>
  <p>Previously, it seems that this was not possible <a href="https://stackoverflow.com/a/18121364/11293694">link</a>. But a release from a few months ago seems to have included the <code>RENAME COLUMN</code> option <a href="https://sqlite.org/releaselog/3_25_1.html" rel="nofollow noreferrer">link</a>.</p>
  <p>This does not seem to work however.</p>
  <pre><code>ALTER TABLE tablename RENAME COLUMN first name TO first_name
  </code></pre>
  <p>The query produces the following error message :</p>
  <pre><code>near &quot;COLUMN&quot;: syntax error: ALTER TABLE tablename RENAME COLUMN
  </code></pre>
  <p>I have including quotation marks for the column name in case whitespace was the issue :</p>
  <pre><code>ALTER TABLE tablename RENAME COLUMN &quot;first name&quot; TO &quot;first_name&quot;
  </code></pre>
  <p>But get the same error.</p>
  <p>This <a href="https://stackoverflow.com/a/52346199/11293694">solution</a> hints that renaming is possible.  But only renames tables (which works fine) but not columns.</p>