DELETE statement
To read more about how sqlx-ts translates query parameters, visit this page
MySQL
Query params within a DELETE statement will be converted Typescript types
const someQuery = sql`
DELETE FROM items WHERE id = ?
`
would generate following
export type SomeQueryParams = [number]
export interface ISomeQueryQuery {
params: SomeQueryParams
results: null
}
PostgreSQL
If you the following query in your Typescript code
const someQuery = sql`
DELETE FROM items WHERE id = $1;
`
would result in
export type SomeQueryParams = [number]
export interface ISomeQueryQuery {
params: SomeQueryParams
results: null
}