title: SQLite prevents duplicate column names in my VIEW
body: <p>I am creating a SQLite VIEW that is the result of multiple joined tables. All my tables have an _id column as required by Android. The result has multiple columns with the same _id name, but SQLite adds ":1" and ":2" to the duplicate names so they are no longer duplicates.</p>
  
  <p>If you run the below SQL you can see the resulting view has interesting column names:</p>
  
  <pre><code>CREATE TABLE things ("_id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "name" TEXT NOT NULL);
  
  CREATE TABLE thing_colors ("_id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "thing_id" INTEGER NOT NULL , "color" TEXT NOT NULL);
  
  INSERT INTO things VALUES ("1","car");
  INSERT INTO things VALUES ("2","horse");
  INSERT INTO things VALUES ("3","lamp");
  
  INSERT INTO thing_colors VALUES ("1","1","blue");
  INSERT INTO thing_colors VALUES ("2","1","red");
  INSERT INTO thing_colors VALUES ("3","2","brown");
  INSERT INTO thing_colors VALUES ("4","3","silver");
  INSERT INTO thing_colors VALUES ("5","3","gold");
  
  CREATE VIEW things_and_colors AS SELECT * FROM things JOIN thing_colors ON things._id=thing_colors.thing_id;
  
  SELECT * FROM things_and_colors;
  </code></pre>
  
  <p>I find these renamed column names useful but is this normal SQL behavior and is it fine for me to rely on it? </p>
  
  <p>But of course this is just an example, in real life I am joining three tables and the result has about 70 columns in it, of which 3 are named _id.</p>