Function unparameterize

app/tests/query2sql.test.ts:22–47

(i: { i: number }, query: CompiledQuery<SqlBool>)

}

function unparameterize(i: { i: number }, query: CompiledQuery<SqlBool>) {
	let parameterizedSql = query.sql
	const parameters = query.parameters
	let j = 0
	while (parameterizedSql.includes('?')) {
		const p = parameters[j]
		parameterizedSql =
			typeof p === 'string'
				? parameterizedSql.replace(
						'?',
						"'" +
							// We need to escape single quote when un-parameterizing the sql.
							// This SHOULD NOT be done in business code!
							p.replaceAll("'", "''") +
							"'",
					)
				: typeof p === 'number'
					? parameterizedSql.replace('?', p.toString())
					: p == null
						? parameterizedSql.replace('?', 'NULL')
						: throwExp(`Unhandled type: ${typeof p}`)
		i.i++
		j++
	}
	return parameterizedSql
}

async function assertEqual(
	actual: string,