add EOF as second delimiter along with ;

Summary

This MR covers 3 issues (#1059, #1065, #1067)

1. #1059 - EOF is added as a second delimiter, but only processed when reading the files (last line of the file can be without a delimiter ;)

2. #1065 - Special commands can be executed with and without specifying delimiter ;

3. #1067 - Additional console prefix(prompt) added '>'. It is shows when input is waiting for delimiter (See example)

• Close #1059, #1065, #1067

• Cherry-pick to: 24.6

• Docs follow-up: docs#403

• Follow-up for !1363 (merged)

Closes #1059, #1065, #1067