SNOW-1318080: local testing move use object logic into session.py for better sql query isolation

SNOW-1318080: local testing move use object logic into session.py for better sql query isolation #6334