Syntax-highlighting for SQL strings in Python code

Question

I'm taking my first steps in SQLite3 in Python using VSCode. My problem is when I use a SQL command there isn't any syntax highlighting.

Is there any way to get the syntax highlighting?

Your editor is using Python syntax highligthing, since you're writting Python. But from the Python point of view the SQL command is just a string, not different from "hello world" and the like. You won't get any syntax highligh within that (VSCode has no way to know that the string is actually a SQL command). Not coindicentally, this happens in all languages and editors. — Alejandro
– Alejandro, Commented Nov 29, 2021 at 12:56
This is supported in the pycharm editor by default. Will highlight any SQL strings and if you have a database connected to the editor, it will even give you autocomplete suggestions — Beefcake
– Beefcake, Commented Nov 24, 2022 at 10:12

Adityan.P · Accepted Answer · 2021-11-29 13:14:09Z

2

It Seems that the SQL Command is just a String and all Editors Work this way and doesn't recognise code inside a String. Anyways found some VS-CODE Extensions that might be of help,

Python String SQL Highlight String Code

answered Nov 29, 2021 at 13:14

Adityan.P

1124 silver badges10 bronze badges

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

Comments

renton01 · Accepted Answer · 2021-11-29 13:14:27Z

2

Update Thank you for your answer, but I've found one way: using Sublime Text. example

answered Nov 29, 2021 at 13:14

renton01

791 silver badge8 bronze badges

Collectives™ on Stack Overflow

Syntax-highlighting for SQL strings in Python code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related