the ITableQuery abstraction in SQLite plugin prevents you from running anything but `select *`

A TableQuery<T> has methods like `Where(Expression...)` and `Orderby` and `Take` that translate into SQL code so that SQLite can return you subsets of entire tables. When you hide a `TableQuery<T>` behind an `ITableQuery<T>` you prevent these methods from being called, meaning that all calls into SQLite select all rows from the entire table, which is then filtered in-memory.

This will have HUGE performance implications.