[Improvement]: Improve the SQL Shortcuts in Terminal Web UI

[wangtaohz]

Search before asking

• I have searched in the issues and found no similar issues.

What would you like to be improved?

Currently, the SQL Shortcuts feature is not user-friendly because it overrides all SQLs in the terminal, causing previous SQLs to be lost.

How should we improve?

Maybe we should append the new SQL demo to the last line instead of overriding all the SQLs.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Subtasks

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[wangtaohz]

Also, there is currently a lack of a SQL demo on dropping table properties, which should be

ALTER TABLE arctic_catalog.db.sample UNSET TBLPROPERTIES ('read.split.target-size');

[tcodehuber]

Can you assign this issue to me?

[zhoujinsong]

Can you assign this issue to me?

Assigned.