Dynamic identifiers such as schema or table name

[kevbook]

In https://github.com/porsager/postgres which has a similar query syntax, there is a way to use dynamic identifiers for schema or table name. Need something similar here as well. Let me know how I can help.

const tableName = 'abc';
await sql`SELECT * FROM ${sql(tableName)}`;

[jawj]

Thanks for the report, and sorry for the delay.

Currently we don't have a mechanism for that, but certainly we should: I'll add it to my TODO list.

In the meantime, you should be able to work around this by using the sql function as an ordinary function, with (...), and providing an ordinary template string as the query. For example:

const tableName = 'abc';
await sql(`SELECT * FROM ${tableName}`);

Obviously be careful with possible SQL injection attacks in this case.

If you also need to pass parameters when using the function like this then you should use $1, $2, etc. For example:

const tableName = 'abc';
const limit = 10;
await sql(`SELECT * FROM ${tableName} LIMIT $1`, [limit]);

[jawj]

In 1.0.0 there is a sql.unsafe('...') method that enables this. For example:

sql`SELECT * FROM ${sql.unsafe(tableName)}`

Careful with it: it's unsafe!