using table.view() more than once produces the same alias in the SQL

[mikehinchey]

This is correct:

t = con.table('omnisci_countries')

t0 = t
t1 = t.view()
x = t0.join(t1, (t0.abbrev == t1.abbrev))
x = x.select([t0.abbrev])
x.compile()

SELECT t0."abbrev"
FROM omnisci_countries t0
  JOIN omnisci_countries t1
    ON t0."abbrev" = t1."abbrev"

Here, the ON clause uses t0 for both sides:

t0 = t.view()
t1 = t.view()
x = t0.join(t1, (t0.abbrev == t1.abbrev))
x = x.select([t0.abbrev])
x.compile()

SELECT t0."abbrev"
FROM omnisci_countries t0
  JOIN (
    SELECT *
    FROM omnisci_countries
  ) t1
    ON t0."abbrev" = t0."abbrev"

Here, t2 is used twice with no t1:

t0 = t
t1 = t.view()
t2 = t.view()
x = t0.join(t1, (t0.abbrev == t1.abbrev))
x = x.join(t2, (t0.abbrev == t2.abbrev))
x = x.select([t0.abbrev])
x.compile()

SELECT t0."abbrev"
FROM omnisci_countries t0
  JOIN omnisci_countries t2
    ON t0."abbrev" = t2."abbrev"
  JOIN omnisci_countries t2
    ON t0."abbrev" = t2."abbrev"