Awesome

JavaScript-SQL Syntax

Purpose

We heavily use SQL-Template-Strings (https://github.com/felixfbecker/node-sql-template-strings) but queries are not colored. This syntax allow SQL syntax highlighting in code like :

var query = SQL`
    SELECT *
    FROM table
    where id = 1
`;

Installation

Create a new syntax with Tools -> Developer -> New Syntax...
Delete the exemple code
Copy everything from the file js-sql.sublime-syntax in the oppened window
Save as js-sql.sublime-syntax

Sublime-linter

Map the js-sql language definition to javascript in order to enable all js linters (jshint, eshint, jscs, etc) with js-sql syntax.

Open Preferences -> Package Settings -> SublimeLinter -> Settings - User and add the key-value entry "js-sql": "javascript" to the syntax_map object.

So now the default syntax_map object is:

"syntax_map": {
    "html (django)": "html",
    "html (rails)": "html",
    "html 5": "html",
    "php": "html",
    "python django": "python",
    "js-sql": "javascript"
}

Usage

Open a js file
Ctrl+Shift+P and type SetSyntax: javascript-sql or ssjssql