Compacted session command history

Overview

The current session command implementation will store all executed session commands regardless of its type. This causes unacceptable memory consumption when executed queries are unique but logically equivalent. An example of this is the USE <database> command which sets the active database for the connection. Only the latest query of this type needs to be stored to retain the state of the session.