{
  "$type": "site.standard.document",
  "description": "Used by *[[SQLite]]*.\n\n## Case insensitivity\n\nThis is valid:\n\n```sql\nSELECT * FROM my_table\n````\n\nBut this is also valid:\n\n```sql\nSelect * from my_table\n```\n\nI use the latter. See my notes on [[Casing|casing]]. This might seem rather confusing. But SQL syntax should be highlighted by the editor. When it comes to in-lining statements in *[[JavaScrip\"...",
  "path": "/SQL",
  "publishedAt": "2026-06-10T01:15:42.000Z",
  "site": "at://did:plc:rfescy2ghdk6ma2wwwhr3bu2/site.standard.publication/3mktkmfk37k2g",
  "textContent": "Used by *[[SQLite]]*.\n\n## Case insensitivity\n\nThis is valid:\n\n```sql\nSELECT * FROM my_table\n````\n\nBut this is also valid:\n\n```sql\nSelect * from my_table\n```\n\nI use the latter. See my notes on [[Casing|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*](https://marketplace.visualstudio.com/items?itemName=qufiwefefwoyn.inline-sql-syntax) for *[[Visual Studio Code]]*.\n\nThis will of course require something called a “tagged template string.”. There’s the [*sql-template-strings*](https://www.npmjs.com/package/sql-template-strings) package. But to just get the syntax highlighting with no extra fancy features, this function is sufficient enough for my needs:\n\n```javascript\n/**https://marketplace.visualstudio.com/items?itemName=qufiwefefwoyn.inline-sql-syntax\n *\n * @param {TemplateStringsArray} str\n * @returns {string}\n */\nconst sql = (str) => {\n\treturn str.join()\n}\n\nconst myQuery = sql`Select * from my_table`\n```\n\nThe 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.",
  "title": "SQL"
}