datafusion-cli: implement syntax highlighting for keywords/literals

[Jefffrey]

Is your feature request related to a problem or challenge?

Currently datafusion-cli has no colour. Adding syntax highlighting can improve usability/readability

Describe the solution you'd like

Highlight SQL keywords and literals in different colours, at the minimum

Describe alternatives you've considered

No response

Additional context

Example of duckdb cli:

Could be useful: https://docs.rs/rustyline/latest/rustyline/highlight/trait.Highlighter.html

[alamb]

This would be awesome

[alamb]

FYI #8918

[alamb]

BTW the other duckdb feature that would be super cool to add to datafusion-cli is the 'duckdb tables' (aka that are formatted nicely based on terminal size and that allow you to scroll left / right)

[SteveLauC]

Hi, this is a really cool feature!

I see that it has been implemented, but I didn't get it with DataFusion cli 36, do I need to enable it somewhere?

Update: I get it, it has been disabled by default in #9013, to enable it, one has to use datafusion-cli --color