Support multiple colums with the same name

[simonw]

I tried this query:

select * from report join location on report.location_id = location.id join state on location.state_id = state.id where state.abbreviation = 'CA' order by report.id desc limit 100

And the resulting table had weird values in the id column - because all three of those tables returned an ID and we run them through a dictionary, which means the last one wins.

[simonw]

Here's the cause of the bug:

django-sql-dashboard/django_sql_dashboard/views.py

Lines 140 to 156 in 9f792ec

	columns = [c.name for c in cursor.description]
	template_name = ("-".join(sorted(columns))) + ".html"
	if len(template_name) < 255:
	templates.insert(
	0,
	"django_sql_dashboard/widgets/" + template_name,
	)
	display_rows = displayable_rows(rows[:100], columns)
	query_results.append(
	{
	"index": str(results_index),
	"sql": sql,
	"rows": display_rows,
	"row_lists": [
	[row[column] for column in columns]
	for row in display_rows
	],

In particular this bit:

django-sql-dashboard/django_sql_dashboard/views.py

Lines 153 to 156 in 9f792ec

	"row_lists": [
	[row[column] for column in columns]
	for row in display_rows
	],