The main way used by SQLAlchemy to figure out what columns are what is using a thing called "column correspondence", which was first introduced in a blog post many ...
PostgreSQL range literals that appear in the SELECT clause (i.e. result columns) of a query are converted to strings as they would be when actually being passed to the database, but are not converted ...