Implement a way to auto-detect session and transaction type #739
Description
Problem to Solve
Some users have described that the UX of selecting session and transaction types every time a query is run is not ideal, especially when repeatedly running the same operations (e.g. define schema, insert data, run test, edit schema/data, repeat).
Current Workaround
Users have to manually select session and transaction types for every query executed.
Proposed Solution
Implement a way to automatically detect the session and transaction type of a query being executed from its structure and keywords, and apply them on execution.
This could potentially take the form of a toggleable button alongside the existing schema, data, write, and read buttons, notionally labelled auto. When auto is toggled on, the other buttons are disabled and greyed out in the same manner as explain is when infer and snapshot are not both switched on. Toggling it off again would re-enable the other buttons. While toggled on, session and transaction types would automatically be inferred from the query being run.
Additional Information
TypeDB Jupyter uses a similar implementation. There are also more complex considerations regarding how non-query panels such as the schema editor will be affected.