sql

Summary

Tagged-template helper for building parameterized SQL statements.

Signature

function sql(strings: TemplateStringsArray, values: unknown[]): SqlStatement;

Example

import { sql } from "remix/data-table";

let email = "[email protected]";
let statement = sql`select * from users where email = ${email}`;
// => { text: 'select * from users where email = ?', values: ['[email protected]'] }

Parameters

strings

Template string parts.

values

Interpolated values or nested SqlStatement values.

Returns

A normalized SqlStatement.