[Sqlalchemy-users] Lazy Loading one or more columns

[Dennis Muhlestein]

I have a table that has a couple informational columns and then a binary (bytea in postgresql) column.  I usually don't want to select the binary data unless I need it.  Is there a way to lazy load columns on a Mapped class?  Because of my special case with that one class, I usually just do a select ( [columns I want] .... ) and manually access the data but it would be nice to use the mapper and then just have the binary data loaded if I access that column.

I could create a relation and put the binary data in another table and lazy load that but then I'd have to do a join every time I did want the data so I guess I chose the lesser of two evils.

-Dennis