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 [email protected] --authenticator externalbrowser
* SnowSQL * v1.3.2
Type SQL statements or !help
[email protected]#MY_DB@(no database).(no schema)>select current_user();
+------------------------------+
| CURRENT_USER()               |
|------------------------------|
| [email protected] |
+------------------------------+
1 Row(s) produced. Time Elapsed: 0.074s
[email protected]#MY_DB@(no database).(no schema)>select current_user();
+------------------------------+
| CURRENT_USER()               |
|------------------------------|
| [email protected] |
+------------------------------+
1 Row(s) produced. Time Elapsed: 0.077s
[email protected]#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.