[Feature] Editors should remember snapshot of the database when they are added to the solution explorer

**Is your feature request related to a problem? Please describe.**
It would be really nice if there was "Revert script" option in Smart AI editor (And potentially other editors when they are added). In order to support this feature, the snapshot of the database should be saved per solution item.

Start by tracing how the Smart AI editor and solution explorer represent editors and solution items. Determine where a database snapshot can be retained per solution item, then verify that the Smart AI editor exposes a working “Revert script” option and that the saved snapshot is restored correctly.

Written by the indexing model from the issue text.