add get_session_info to HistoryManager for querying session table...
add get_session_info to HistoryManager for querying session table
Also set detect_types flags on the connection, so timestamps are
retrieved as datetime objects.
Associated type checking test included.