In SQLAlchemy core, the result is RowProxy. In cases where you want an explicit dictionary, you can call dict(row).
First the setup for the example:
import datetime as dt
from sqlalchemy import (
Column, Date, Integer, MetaData, Table, Text, create_engine, select)
metadata = MetaData()
u...
