What is the best practice when making DB calls:

Just use pub.db:execSQL to make call or use a structure like use pub.db.connect, then the execSQL, then use pub.db.close to clean ub connection?

I am concerned about keeping the sessions to the DB clean.

By using just the execSQL, how are the sessions cleaned up? Through the db Alias timeout?