SQL

Used by SQLite.

Case insensitivity

This is valid:

SELECT * FROM my_table

But this is also valid:

Select * from my_table

I use the latter. See my notes on casing. This might seem rather confusing. But SQL syntax should be highlighted by the editor. When it comes to in-lining statements in JavaScript code, I use Inline SQL for Visual Studio Code.

This will of course require something called a “tagged template string.”. There’s the sql-template-strings package. But to just get the syntax highlighting with no extra fancy features, this function is sufficient enough for my needs:

/**https://marketplace.visualstudio.com/items?itemName=qufiwefefwoyn.inline-sql-syntax
 *
 * @param {TemplateStringsArray} str
 * @returns {string}
 */
const sql = (str) => {
	return str.join()
}
 
const myQuery = sql`Select * from my_table`

The extra typing is there to keep TypeScript happy. I get that string interpolation can’t be used. But I’m handing that off to whichever is setting the prepared statement.