The three execute methods of the connection object return the created cursor. The term "intermediate" implies the cursor is totally handled by the execute method, not that the user will get ownership of the object. 

When the user doesn't call close() on the returned cursor right away, they hold a lock on the database until the object is garbage collected.