VS Code syntax highlighting for SQL commands in Python

Question

The first syntax highlighting is of VS Code and the second one is of Sublime Text. I searched for extensions but I couldn't find anything which could detect SQL commands like CREATE TABLE and highlight them or suggest them as I start typing.

Sublime Text and Atom have this feature by default, but I can't get it to work in VS Code.

I am working with .py files so the syntax highlighting works only for Python commands and the whole text (inside quotes) is treated as string in VS Code.

Is there any fix to get syntax highlighting like Sublime Text / Atom in VS Code when working with SQL syntax in .py files or highlighting commands even if it's inside quotes ("")?

informatik01 · Accepted Answer · 2022-03-13 11:25:53Z

8

It seems the VS Code doesn't support this feature officially. Hence, I make an extension called Highlight String Code which can highlight SQL expressions in Python or any other language.

You can easily use it by uppercasing the first keyword of the SQL command and adding a semicolon at the end:

I hope the extension can be helpful.

edited Mar 13, 2022 at 11:25

informatik01

16.5k11 gold badges82 silver badges112 bronze badges

answered Sep 28, 2020 at 6:08

iuyoy

1511 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hank Over a year ago

brilliant extension! Works right away, thanks a lot!

dofire Over a year ago

great extension. You saved my day!

Collectives™ on Stack Overflow

VS Code syntax highlighting for SQL commands in Python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related