Raw() parameters name uniqueness

[alexey-pelykh]

Feature Description

Consider the following example:

{
  someFieldA: Raw((columnAlias) => `${columnAlias} = :param`, { param: 5 }),
  someFieldB: Raw((columnAlias) => `${columnAlias} = :param`, { param: 0 }),
}

In this case it's a design restriction that param has to be named uniquely every time manually.

The Solution

It would be nice to have a signature that allows to do the following:

{
  someFieldA: Raw((columnAlias) => `${columnAlias} = :${columnAlias}`, (columnAlias) => ({ [`${columnAlias}`]: 5 })),
  someFieldB: Raw((columnAlias) => `${columnAlias} = :${columnAlias}`, (columnAlias) => ({ [`${columnAlias}`]: 0 })),
}

This would allow an elegant way to avoid naming collision in decoupled code.

Considered Alternatives

Alternative, we can consider the following approach:

{
  someFieldA: Raw((columnAlias) => `${columnAlias} = :{0}`, [ 5 ]),
  someFieldB: Raw((columnAlias) => `${columnAlias} = :{0}`, [ 0 ]),
}

where {0} and so on would be automatically replaced with auto-generated param names.

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.