Question: SQL functions and string literals

[jeofo]

Hi,
Here's an example query I'm trying to make that involves a SQL function, here I'm using the Apache AGE extension but I'd assume all functions should work similarly.

export const cypher = async (graph: string, query: string, type: string[]) => {
  const a = 'users';
  const b = 'RETURN 1';
  const q = await sql`
      SELECT * FROM cypher('${a}', $$ ${b} $$) AS (n agtype)
    `;
...
};

The query above doesn't work with error:

PostgresError: graph "$1" does not exist

Further debugging shows, when code is modified to:

export const cypher = async (graph: string, query: string, type: string[]) => {
  const a = 'users';
  const b = 'RETURN 1';
  const q = await sql`
      SELECT * FROM cypher('users', $$ ${b} $$) AS (n agtype)
    `;
...
};

I get

PostgresError: unexpected character at or near "$"

And lastly, if the entire literal is entered

export const cypher = async (graph: string, query: string, type: string[]) => {
  const a = 'users';
  const b = 'RETURN 1';
  const q = await sql`
      SELECT * FROM cypher('users', $$ RETURN 1 $$) AS (n agtype)
    `;
...
};

the query works.

How should I interact with functions? Thanks.

I know that sql.unsafe() works, but trying my best to avoid.