SudoSOS Back-end API / helpers/params / convertToPositional

Function: convertToPositional()

function convertToPositional<T>(sql, params): object;

Converts SQL with :named parameters and a params object to SQL with positional (?) placeholders and a matching array. Handles each parameter only in the order it appears in the SQL.

Type Parameters

Type Parameter
T extends Record<string, unknown>

Parameters

Parameter	Type
sql	string
params	T

Returns

object

sql

sql: string;

values

values: T[keyof T][];