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 and a semicolon, -- endsql, or -- end-sql at the end of the highlighted section. With MYSQL: the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character (such as a space, tab, newline, and so on)

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.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