SNOW-1669337: Please add a REPL to snowflake-cli

[jamiekt]

Description

The feature of snowsql that I use constantly is the REPL. For example:

➜  ~ snowsql -a XXX.eu-west-1 -u jamie@myorg.com --authenticator externalbrowser
* SnowSQL * v1.3.2
Type SQL statements or !help
jamie@myorg.com#MY_DB@(no database).(no schema)>select current_user();
+------------------------------+
| CURRENT_USER()               |
|------------------------------|
| jamie@myorg.com |
+------------------------------+
1 Row(s) produced. Time Elapsed: 0.074s
jamie@myorg.com#MY_DB@(no database).(no schema)>select current_user();
+------------------------------+
| CURRENT_USER()               |
|------------------------------|
| jamie@myorg.com |
+------------------------------+
1 Row(s) produced. Time Elapsed: 0.077s
jamie@myorg.com#MY_DB@(no database).(no schema)>

However there is no such REPL in snow as far as I can tell. snow sql has -q, -f, -i options, but those aren;t equivalent to snowsql's REPL

Context

snow seems like the "do everything" CLI tool that Snowflake needs however until it has an interactive REPL I'll have to go on using both snow & snowsql, and I'd rather not have to do that.