store: refactor `queries.rs` and `types.rs`

The `queries.rs` file has grown to 1.5k loc which is far too many. There are also types that are oftentimes only relevant to a single query or insert/upsert that accumulated in `types.rs`.

The goal is to find a more coherent way of rerpresenting the queries, where all relevant types "live together".