vscode-sql-lit

Syntax highlighting for SQL tagged template literals in JavaScript and TypeScript.

Pairs nicely with the following packages:

• postgres
• slonik
• @slonik/typegen
• sql-template-strings

Main Features

SQL syntax highlighting is triggered in a couple of ways:

• tagged template literals via a sql* or db* identifier
• a .sql or .db method invoked as a template tag
• template literal strings with a /* sql */ or /* db */ comment prefix

Samples

Basic Tag

Tag Method

Interpolated Values

TypeScript

PL/PgSQL

Slonik

Slonik Typegen

Slonik Validation

Template Comment Prefix

File Types

• .js
• .jsx
• .ts
• .tsx
• .vue

Advanced Language Support

None. This extension only offers syntax highlighting.

Be sure to follow best practices documented in your database driver package of choice to mitigate sql injection vulnerabilities!