Speaking of "closer to the database" Ecto is now one of my all-time favorite libraries.

Every time I think "this is going to be tricky".. nope. Ecto seems to have thought of that.