re-architect FTS queries

[Mattwmaster58]

currently we query like this (implicitly). The problem with this is that any indexes on auction_lot will not/cannot be used, and FTS virtual tables cannot index anything other than text.

flowchart LR
    query <--> auction_lot_fts <--> auction_lot

Loading

Instead, we should likely do something like this with a join

flowchart TD
     auction_lot_fts --> query
     auction_lot --> query

Loading