Evaluate adding a way to re-use value bindings

[gajus]

Consider this scenario:

sql.fragment`SELECT ${'a'}, ${'a'}, ${'a'}`

The resulting object is:

SELECT $1, $2, $3

with values ['a', 'a', 'a']

I wish we had a way to re-use the same value binding, e.g.

const value = sql.value('a');

sql.fragment`SELECT ${value}, ${value}, ${value}`

With the outcome of:

SELECT $1, $1, $1

and values ['a']

[wozprzemek]

Hi, could I work on this one?

[wozprzemek]

What if we consider, e.g. nested sql.fragments, like in the simplified example:

const value = sql.value('a');
const nestedFragment = sql.fragment`SELECT ${value}`

sql.fragment`
  SELECT ${value}, ${value}, ${value},
  ${nestedFragment}
`

I understand that an example like this would also re-use the same value binding and produce the values ['a']?: