Syntax highlighting: SQL #2063

mharig · 2022-03-14T15:05:20Z

mharig
Mar 14, 2022

Is it planned? How may I help implementing it?

from rich import print
from rich.syntax import Syntax
print(Syntax("SELECT * FROM Customers WHERE CustomerID=1;", lexer="mysql", theme="monokai"))

willmcgugan · 2022-03-14T15:49:57Z

from rich import print
from rich.syntax import Syntax
print(Syntax("SELECT * FROM Customers WHERE CustomerID=1;", lexer="mysql", theme="monokai"))

2 replies

I see, thanks. What extension does rich-cli expect for a SQL file, then? It does not work with .sql .

After a quick look in the rich-cli source code, I found that it supports all that pygments support.
Syntax e.g.:
rich --lexer sql <myscript.sql>