SNOW-2282856: Add option for SQL repl to work in a "dumb" terminal

[jdormit]

Description

I would like to be able to use a snow sql REPL in Emacs' comint-mode. Unfortunately, something about the way to REPL works is prevent any I/O between Emacs and the snow subprocess. I suspect this has to do with the autocomplete functionality, although I haven't proved it yet.

So the ask is: can there be a switch that will allow the snow sql REPL to work with stdin and stdout in the normal way, allowing it to work with such wrapper programs? Perhaps this would be as simple as adding a switch to disable autocomplete.

For a minimal reproduction, evaluate this in Emacs with M-x eval-expression:

(progn
  (comint-run "snow" '("sql" "-c" "prod"))
  (setq-local comint-process-echoes t))

Context

No response