Highlighter for mysql

[sparcbr]

Does anyone already managed to make a SQL highlighter work with zsh-syntax-highlighting ?

I plan to make it work when calling commands like mysql -e 'SELECT ...', mycli and also for my sql scripts like:
sql "SELECT ..."

Any tips on or similar commands that call custom highlighters are welcome..

Thanks!

[danielshahaf]

I'm not aware of prior art in this area, though there are related tools, such as pygmentize and edit-command-line.

I guess the first design decision is whether to implement an SQL parser in zsh or to shell out to an existing, external parser.

What about SQL scripts in heredocs in interactive shells (at the $PS2 prompt)?