Originally opened as issue and a discussion in the organization repo (probably the wrong locations):

• IssueJS + TS Template Literal Support #20
• Organization-level discussionhttps://github.com/orgs/supabase/discussions/16286

Hi there 👋 First of all, thanks for all of the effort that Supabase is putting into the PostgreSQL community, including tooling, really amazing 🙌

I recently encountered Postgres Language Server viathe recent tweet from@kiwicopple and it looks amazing!

I have been chasing the "holy grail" of tooling for SQL template literals in JavaScript + TypeScript for a while now:

• syntax highlighting (works, with the VS Code extensionSQL tagged template literals (syntax only))
• linting (works, usingSafeQL)
• formatting, some options
  • prettier-plugin-embed andprettier-plugin-sql - usessql-formatter
  • kind of works, witheslint-plugin-sql andeslint-plugin-unicorn, but very opinionated / not so configurable - usespg-formatter
  • @potygen/prettier-plugin-pgsql by@ivank - uses custom Prettier AST formatter

Wasn't even looking for inline documentation yet, but that's a great addition too!

It seems that the plan will be for Postgres Language Server to support all of these use cases, which is amazing!

I would love to have everything handled by one highly-battle-tested tool, which could maybe also deal with some of the shortcomings from the tools listed above.

However, for Postgres Language Server to work for any of our projects, it would need a feature which I'm not sure it currently has (can't tell, from a quick glance at the docs and the code):

• Support for tagged template literals in JavaScript and TypeScript

There is precedent for SQL tagged template literals in JS+TS, some of the more popular ones being:

• Postgres.js
• @vercel/postgres

Eg. I would love for all of the features of Postgres Language Server to be available in the following code block:

import{createClient}from'@vercel/postgres';asyncfunctionqueryPosts(){constclient=createClient();awaitclient.connect();try{constlikes=100;const{ rows, fields}=awaitclient.sql`SELECT * FROM posts WHERE likes >${likes};`;}finally{awaitclient.end();}}

Or this code block:

// db.jsimportpostgresfrom'postgres'constsql=postgres({/* options */})// will use psql environment variablesasyncfunctiongetUsersOver(age){constusers=awaitsql`    select      name,      age    from users    where age >${age}  `// users = Result [{ name: "Walter", age: 80 }, { name: 'Murray', age: 68 }, ...]returnusers}asyncfunctioninsertUser({ name, age}){constusers=awaitsql`    insert into users      (name, age)    values      (${name},${age})    returning name, age  `// users = Result [{ name: "Murray", age: 68 }]returnusers}