sql

View Source

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]'] }

Params

strings

Template string parts.

values

Interpolated values or nested SqlStatement values.

Returns

A normalized SqlStatement.