Support for SQLite non-string parameters
Author: simonwCreated Sep 17, 2026Updated Sep 17, 2026
Labelsresearch
Currently all ?param= we send are treated as strings by SQLite.
This works OK for some cases - where age > :age for example - because SQLite knows the column is an integer type and coerces the value for us.
It breaks for columns like where age + 1 > :age.
Should Datasette have a mechanism for sending an integer parameter in a query string?
Source: simonw/datasette