SQL highlighting in Python multiline strings for VS Code

Adds syntax highlight support for python multiline SQL strings in VS Code.

Installation

Install python-string-sql from extensions (ctrl + shift + x or cmd + shift + x on mac).

Also available on marketplace.visualstudio.com

Example

Usage

Insert --sql, --beginsql, or --begin-sql at the beginning of the part of the string you would like highlighted (with or without a space after --, e.g. -- sql) and a semicolon, --endsql, or --end-sql at the end of the highlighted section.

Snippets

begin typing sql and the autocomplete snippet will appear:

Keybindings

cmd+s (or ctrl+s on mac) - Insert the following snippet:

"""
--sql
SELECT
;
"""

Requirements

• Visual Studio Code v1.32.0 recommended
• Comments at beginning and end of highlighted section in the string (see Usage section).

Community

• 2018-09-04 forked from es6-string-css

Release Notes

[1.2.0] - 2023-11-06

• Added support for mysql by allowing a space after --

[1.1.0] - 2019-06-04

• Added support for f-strings

[1.0.0] - 2019-03-29

• Added snippet and keybinding

[0.1.0] - 2019-03-28

• Published on VS Code marketplace

[0.0.1] - 2019-03-28

• Got it working based on these instructions

[0.0.0] - 2018-09-04

• Forked from es6-string-html