```python
results = [dict(zip(("category", "rule"), x) for x in sql_results]
```

I wrote that to see how it looked and I like it. What do you think? It fits in the 79 chars limit, and it's one line instead of 7.