Query console
Two ways to ask SQLite the same question: DocumentDb's string query grammar, or the database's own SQL.
The same grammar Query<T>().Where("…") takes, lowered to the same SQL — so
what comes back here is what your code would get. Field paths are dotted. Because there is no
CLR type to infer from, a path may carry a :type hint (number,
int, date, bool, guid, …) and needs
one wherever nothing else pins it — notably an OrderBy over a numeric field,
which otherwise sorts as text and puts "100" before "9".
Runs in SQLite's own dialect.
@name placeholders work on every provider — the connection rewrites them — and are
bound from the parameters box below.