Skip to main content

Module params

Module params 

Source
Expand description

What a caller binds into its own SQL.

SQLite has one parameter space and four spellings for a slot in it: ?, ?N, :name, @name and $name. A store that accepted only the numbered form would not be refusing anything on an invariant’s behalf — it would simply be handing the work back, because SQL written with named placeholders then has to be rewritten before it can be run, and rewriting it means reading it: skipping string literals, and the literals here include json_extract(data, '$.n').

So both forms are bound, and Params is which one a call is making.

Enums§

Params
Values for a statement’s placeholders, by position or by name.