Quote from the documentation:
fetch* methods of the cursor class by default return result set values
as a tuple, unless named_tuple or dictionary was specified.
The latter one exists for compatibility reasons and should be avoided
due to possible inconsistency in case two or more fields in a result
set have the same name.

"The latter one" refers to dictionary, but should refer to named_tuple.