results.dict() method for SQL query results

[simonw]

I find myself using this pattern all the time:

rows = [dict(r) for r in (await db.execute("select * from t"))]

I'm going to add a utility method like this:

rows = (await db.execute("select * from t")).dicts()

Relevant code:

datasette/datasette/database.py

Lines 658 to 684 in dc28805

	class Results:
	def __init__(self, rows, truncated, description):
	self.rows = rows
	self.truncated = truncated
	self.description = description
	@property
	def columns(self):
	return [d[0] for d in self.description]
	def first(self):
	if self.rows:
	return self.rows[0]
	else:
	return None
	def single_value(self):
	if self.rows and 1 == len(self.rows) and 1 == len(self.rows[0]):
	return self.rows[0][0]
	else:
	raise MultipleValues
	def __iter__(self):
	return iter(self.rows)
	def __len__(self):
	return len(self.rows)

[simonw]

Could I get it to work like this instead?

rows = await db.execute("select * from t").dicts()

Bounced the idea through Claude: https://gist.github.com/simonw/c6b7d46da9e145676f6f1c0785e518c3 - but I don't think I'm going to do it. It's just a little bit complicated to explain to end users, especially if they don't use it quite right and have to untangle what happened.