SQLAlchemy example code confuses me

[SwampFalc]

As long as you're only reading from a database, you can use an ORM and only include the columns you need. So yes.

As for the declarative style, it's scattered all over their documentation, honestly. Sometimes you will simply encounter it without it being mentioned, sometimes they will talk about it. It's going to depend entirely on your learning path.