postgresql: annotate transaction with the proper DictCursor type

mypy would complain that the result of cursor.fetch*() are tuples and
not mappings.