title: How to syntax-highlight / autocomplete / autoformat SQL commands inside JavaScript / Node.js files in Visual Studio Code?
body: <p><img src="https://i.stack.imgur.com/N4toR.png" alt="Color highlighting in .js file" /></p>
  <p><img src="https://i.stack.imgur.com/v0iOZ.png" alt="Color highlighting in .sql file" /></p>
  <p>Right now, the SQL command is treated like a string and have to be manually formatted by capslock if it is inside a JavaScript function. For example:</p>
  <pre class="lang-js prettyprint-override"><code>const sqlite3 = require('sqlite3').verbose();
  
  let db = new sqlite3.Database('../db/test.db');
   
  let sql = `create table person (
      id BIGSERIAL NOT NULL PRIMARY KEY,
      first_name VARCHAR(50) NOT NULL,
      last_name VARCHAR(50) NOT NULL,
      gender VARCHAR(6) NOT NULL,
      date_of_birth DATE NOT NULL,
      email VARCHAR(150));
  insert into person (first_name, last_name, gender, date_of_birth) values ('Anne', 'Smith', 'Female', '1988-01-09');
  insert into person (first_name, last_name, email, gender, date_of_birth) values ('Jake', 'Jones', 'jake@gmail.com', 'Male', '1990-12-31');`;
  </code></pre>
  <p>The long SQL command will show as a block of green text in my VS Code (following my color scheme for string).</p>
  <p>The desired color scheme is as if I put it in an sql file, eg:</p>
  <pre><code>create table person (
      id BIGSERIAL NOT NULL PRIMARY KEY,
      first_name VARCHAR(50) NOT NULL,
      last_name VARCHAR(50) NOT NULL,
      gender VARCHAR(6) NOT NULL,
      date_of_birth DATE NOT NULL,
      email VARCHAR(150));
  enter image description hereinsert into person (first_name, last_name, gender, date_of_birth) values ('Anne', 'Smith', 'Female', '1988-01-09');
  insert into person (first_name, last_name, email, gender, date_of_birth) values ('Jake', 'Jones', 'jake@gmail.com', 'Male', '1990-12-31');
  </code></pre>
  <p>has the colors:</p>
  <ul>
  <li>orange for words like create table, insert into, not null, primary key, varchar, etc</li>
  <li>white for person, id, first_name, last_name, gender, etc</li>
  <li>green for 'Anne', 'Smith', 'jake@gmail.com', etc</li>
  <li>purple for bigserial
  (for some reason the color does not show on stackoverflow's codeblock)</li>
  </ul>
  <p>Maybe through an extension or through vscode settings?</p>