sqlParams.ts

// Converts SQL query from named parameters :param to [param]
export const sqlParams = (
  sql: string,
  params: Record<string, any>
): [string, any[]] => {
  const matches = sql.split(/([^:]:[A-z]+[A-z0-9])/g);

  let i = 0;
  const nextParams: any[] = [];
  const nextSql = matches.map((str, index) => {
    const isParam = index % 2 === 1;
    if (!isParam) {
      return str;
    }

    const prefix = str.slice(0, 1);
    const paramName = str.slice(2);
    const nextToken = `$${++i}`;

    const param = params[paramName];
    if (!params.hasOwnProperty(paramName)) {
      console.warn(`sqlParams - missing parameter: '${paramName}'`);
    }
    nextParams.push(param);

    return prefix + nextToken;
  }).join('');

  return [nextSql, nextParams];
};