#2946·datasette

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?