title: Why would SQLite allow a table with nameless column?
body: <p>Looks like SQLite allows a table to be created with 1 nameless column. Any reason why?</p>
  
  <p>Hi,</p>
  
  <p>I recently discovered that I can create a table in SQLite where one of its column has no name. Like this:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS customer_data (
      ""             TEXT,
      "collect_date" TEXT,
      "first name"   TEXT,
      "last name"    TEXT,
      "last_visit"   TEXT
  );
  
  </code></pre>
  
  <p>The first column is an empty string. And looks to me that SQLite actually allows this. I proceed to insert some data into this table:</p>
  
  <pre><code>INSERT INTO customer_data VALUES ('a', '2019-07-01 21:22:05', 'Joe', 'Johnson', '2019-06-22 14:33:01');
  INSERT INTO customer_data VALUES ('d', '2019-07-01 21:22:05', 'Sam', 'Somelove', '2019-06-13 12:11:02');
  INSERT INTO customer_data VALUES ('g', '2019-07-01 21:22:06', 'Bill', 'Bullock', '2019-06-24 10:23:07');
  INSERT INTO customer_data VALUES ('j', '2019-07-01 21:22:08', 'Tim', 'Thomas', '2019-06-04 16:34:18');
  
  </code></pre>
  
  <p>SELECT 'em back:</p>
  
  <p><code>SELECT * FROM customer_data;</code></p>
  
  <p>Sure enough, here's the data:</p>
  
  <pre><code>&lt;anonmymous&gt;   collect_date .       first name  last name   last_visit
  ---------------------------------------------------------------------------
  a              2019-07-01 21:22:05  Joe         Johnson     2019-06-22 14:33:01
  d              2019-07-01 21:22:05  Sam         Somelove    2019-06-13 12:11:02
  g              2019-07-01 21:22:06  Bill        Bullock     2019-06-24 10:23:07
  j .            2019-07-01 21:22:08  Tim         Thomas      2019-06-04 16:34:18
  </code></pre>
  
  <p>My question is:
  1. Why would SQLite an CREATE TABLE statement with a nameless column?
  2. How would one access such column individually.</p>