/python-string-sql

Highlight code in python multiline strings

MIT LicenseMIT

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

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:

Snippet

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

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

[0.0.0] - 2018-09-04

  • Forked from es6-string-html